How the proposed er model could accommodate

Assignment Help Database Management System
Reference no: EM131311743 , Length: word count:200

Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scenario and be able to conduct optimal strategies for efficient management of databases.

Intended Learning Outcomes covered:

1. Design the logical structure of a database using Entity-Relationship diagram.

2. Apply normalization techniques to reduce redundancy in a database.

Task 1:

Complete the work proposal in Microsoft Word file format (may include possible answers based on your initial understanding). Work proposal for the assignment and must include:
- What you will do with the given tasks: task 2, task 3 and the dates (timeline) by when they will be completed
- General overview of initial understanding of solutions to task 2 and task 3
- Identification of Literature Resources

Task 2: Scenario:

Apollo Hospitals (AH) is a popular medical service provider in Oman. AH wants to automate its business functions into an information system. The proposed information system must be developed keeping in mind the following business rules. As part of this, you need to analyse and develop an Entity Relationship model depicting the following various business requirements and functionalities for the proposed Pharmacy Information System of AH.

Dr. Prathap Reddy, Chairman, is aware that other multi-specialty hospitals are coming up in a big way and AH will face fierce competition from new healthcare systems. So, he has decided to take all measures to always be ahead of others in the market. It is increasingly important to AH that Reddy be able to analyse services rendered by AH and perception of patients more thoroughly.

The Pharmacy places requests to the Purchase Department whenever it is in need of drugs. Pharmacy is identified by unique id, name and telephone number. Purchase Department is identified by a unique number. The other elements are phone number, manager. The Purchase Department submits many orders or may not submit an order. An order is uniquely identified by an id. The other elements of order are placement date, fulfillment date, received date, order amount. An order consists of one or more drugs or items. A drug is supplied by one or more supplier. A supplier supplies many drugs or may not supply a drug. Whenever a supplier supplies a drug, AH wants to record the shipment details such as date of supply. The elements of drug are unique id, name, type, manufacturer id, manufacture date, expiry date, batch number, unit cost. A supplier is uniquely identified by id. The other elements of supplier are name, address, phone number, email, location and track record.

a) Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify all the entities, attributes of each entity including primary key, relationship between the entities and cardinality constraints. State any assumptions necessary to support your design.

b) For the task 2a, analyse and recommend how the proposed ER model could accommodate the shipment and payments.

Task 3:

a) Normalize the below given Patient Prescription Bill to First Normal Form, Second Normal Form and Third Normal Form.

b) For the finally arrived normalized form in task 3a above, discuss how the redundancy has been minimized.

Task 4: Be ready for a written viva to demonstrate your knowledge with the different concepts used in preparing the assignment. Schedule for the written viva will be announced in the class and on Moodle/MEC mail. Marks for task 2 and task 3 will depend on the written viva.

Note: Task 4 is compulsory. No marks will be awarded to tasks 2 & 3 if written viva is not taken by a student.

Reference no: EM131311743

Questions Cloud

Which industries are the most dominant : Which industries are the most dominant?- Prepare a short class presentation on why that company is among the 100 best to work for.
Term paper-crowdsourcing : Crowdsourcing in the field of interface design takes tasks traditionally performed by specific individuals and spreads them out among a group of people or a community. These assignments are usually done through an open call. Crowdsourcing has beco..
Provide an overview of current global agreement surrounding : Provide an overview of the current global agreement surrounding the Production and Technology Structures. In doing so, focus on the key organizations and the international legal principles which they embody.
What is the economic argument for deregulation : What are the limitations of the Laffer curve as a tool of government policy formulation?
How the proposed er model could accommodate : Relational Database Systems (COMP 1005) Design the logical structure of a database using Entity-Relationship diagram and Apply normalization techniques to reduce redundancy in a database - Normalize the below given Patient Prescription Bill to First ..
Series-parallel resistive circuits : Discuss how you can identify which resistances are in series and which ones are in parallel in a series-parallel circuit. How might this affect how you measure current and voltages in the circuit with a digital multimeter?
Design a poster you could use to further public awareness : select one of these crimes and search the Argosy University online library or other academic sources to locate at least one article describing research findings related to the crime and its victims. Design a poster you could use to further public ..
Summarize the view of american critics of global firms : Summarize the view of American critics of global firms that import products purchased from developing country factories that have bad working conditions and pay very low wages. Also, summarize Dr. Krugman's rebuttals.
Companies protect their digital assets overseas : Prepare a 3 to 5 paragraph briefing statement that can be used to answer the above question. Your audience will be attendees at a conference for small business owners who are interested in expanding their footprint overseas (sales, offices, produc..

Reviews

len1311743

12/14/2016 4:57:44 AM

• Design the logical structure of a database using Entity-Relationship diagram. Critical Thinking, Analytical, Comparing, Contrasting, Decision-making, Data Modeling, Researching, Making judgment about complex issues, Communicate conclusions effectively. • Apply normalization techniques to reduce redundancy in a database. Critical Thinking, Analytical, Cognitive, Problem Solving, Evaluating Evidence, Making judgment about complex issues, Researching, Demonstrate Creativity, Communicate conclusions effectively.

len1311743

12/14/2016 4:57:25 AM

Use page numbers Assignment should be typed in your own words using Times New Roman font size 12. Heading should be with Font Size 14, Bold, Underline Use Diagrams and Examples to explain your topic. Copy paste from the Internet or other student work is strictly not acceptable. References should be included in the last page as follows Author name, Book Title, Publisher, Year in case of books In case of web site references type the full path of the web page with referenced date In case of journals/magazines/periodicals type article name, magazine name, Issue Number and date

len1311743

12/14/2016 4:57:13 AM

Guidelines - Follow the guidelines mentioned below for your assignment. - Submit a work proposal detailing aspects such as initial understanding of the given tasks, timelines to complete each task, literature sources for solving the tasks. - Assignment should be typed and uploaded to Moodle and will undergo plagiarism detection test through Turnitin (a plagiarism detection tool) - Handwritten assignments will not be accepted. - Assignment should have a Title Page. Title Page should contain the following information. - Assignment Name - Class - Student name - Student ID - It should have Table of Contents

Write a Review

 

Database Management System Questions & Answers

  Explain data for each candidate of eight constituencies

supplies % of votes each candidate is likely to receive, based on popularity rating. Actual number of votes received is that percentage of General votes. You should enter data for each candidate in each of the eight constituencies.

  Design relational database using entity-relationship diagram

Design a Relational Database using Entity-Relationship Diagram (ER-D) and design a Relational Database by Mapping Entity-Relationship Diagram (ER-D) into Relational Models.

  Types of input control and explain the function of each

Explain the function of input controls. Identify four (4) types of input control and explain the function of each

  How does access identify each record within a database

How does Access identify each record within a database? What is the benefit for your data entry people by providing their data entries via combo boxes? What is the purpose of creating a lookup column in Access?

  Advantage of nosql databases

In this forum, describe your current organization or school (industry, size, processes, etc...) and discuss whether/how it could take advantage of NOSQL databases.

  Create a multitier application

Create a multitier application: Use a grid control to display customer information from the Customers table of the Northwind database

  What is denormalization, and why can it be desirable

When is it important to denormalize a database? Can you provide an example/examples?

  Pros and cons in agile and waterfall project management

Evaluate the pros and cons in agile and Waterfall project management in terms of planning and the execution of projects and collaboration among project team members.

  Part 1 - reportwrite a 2000-word report that describes a

part 1 - reportwrite a 2000-word report that describes a suitable methodology from the literature for the purpose of

  What is data mining

What is data mining. What specific data elements are stored on your card subject to monitoring by the chain. Does this concern you from a privacy perspective

  Part a major change definition and facilitating

part a major change definition and facilitating forces1.discuss the differences between a voluntary change and an

  Evaluate requirements and select appropriate parameters

Advanced Database Administration (COMP 0343) Manage client-server connections using RDBMS Net Services - Evaluate requirements and select appropriate parameters to ensure effective storage management in a database system.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd