Analyse business decisions related to db information systems

Assignment Help Database Management System

Reference no: EM132122829

Data model development and implementation

Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain understanding of data model development. Then implement the data model using a commercially available database management system development tool.

On completion of this assignment students will be able to:
- Make an informed and critical assessment of database management systems.
- Develop data models and implement DB systems.
- Analyse business decisions related to DB information systems.
- Demonstrate skills in building a database application using a commercially available database management system development tool.

Assignment Description

Part B:

1. Knox private Hospital contracted with GeenIT services to develop and design their hospital database, the hospital IT Manager provided the following business rules to the GreenIT services software developer:

User view 1 requirement :Patients are identified by a PatientID, and their names, addresses, and ages must be recorded.

User view 2 requirement : Doctors are identified by a DoctorID. For each doctor, the name, specialty, and years of experience must be recorded.

User view 3 requirement :Every patient has a primary physician/doctor. Every doctor has at least one patient.

User view 4 requirement :Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription can have more than one drug.

User view 5 requirement: For each drug, identified by DrugID and the trade name and formula must be recorded.

User view 6 requirement: Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.

User view 7 requirement:Each pharmacy has a unique name, address, and phone number.

Complete the information-level design for the database that satisfies the above constraints and user view requirements. In order to complete this information-level design you are required to answer questions given below 1(a) - (f).

1.
a. Analyse the all user requirements given above, identify and list all entities described in all user requirement.

b. Add attributes to these entities and represent these entities (or Tables) and attributes as a collection of Tables and attributes. You are required to arrange them as given in the example below.
NB: Select suitable primary key for each table and underline them.
Eg. Patient (PatientID, name,.......)
c. Outline at least 2 relationships between those entities.
Eg.Every patient has a primary physician/doctor. - One-to-many.

d. Determine the functional dependences.
Eg.PatientID → name, address, age, ......

e. Normalise the tables.

2. Represent the structure of your database visually by using the entity-relationship (E-R) diagram. If you make any assumptions about data that are not explicitly given in the problem, thesemust be described. You need to use Visio or any other software tool to create the ER diagram.

3. Build this model using MS Access by creating these tables and Relationships in Access. Populate these tables with appropriate data, at least 2 records in each table. Include following into your MS Word document.

I. Relationship diagram created in Access. (Select database tools → Relationships in the Access menu)

II. Data sheet view and design view of your tables.

4. Give one example for the type of report that can be obtained from this "Knox private" database.

Attachment:- Data model development and implementation.rar

Reference no: EM132122829

Questions Cloud

How could legislation impact on operations : How could legislation impact on operations within your organisation in relation to innovation, project management

Determine client net capital gain or net capital loss : HI6028 Taxation Theory, Practice & Law Assignment, Holmes Institute, Australia. Determine your client's net capital gain or net capital loss for the year ended

Dana hires paris to paint a portrait of her poodle : Dana hires Paris to paint a portrait of her poodle, "Mack." The painting is to be done to Dana's personal satisfaction.

Google management influence organizational culture : How Google management influence the organizational culture in the company.

Analyse business decisions related to db information systems : BN204 - Database Technologies - Data model development and implementation - Develop data models and implement DB systems

How you might design a study to gather data : Post your explanation of what you think the social workers wanted to know when they designed the pre/posttest for evaluating the parenting classes.

Behavior that occurred outside hospital environment : Was it appropriate for hospital administration to discipline the doctors and nurses for behavior that occurred outside the hospital environment?

How the article supports your research paper : Select 10 scholarly articles dealing with styles of leadership with in a organization that will support your research paper. Write an annotated bibliography.

Describe the process of developing descriptions : For this discussion, you will be creating your Personal Learning Profile (PLP). As Dr. Johnston said in the video, you want to be able to frame your description

Reviews

len2122829

9/26/2018 12:24:36 AM

Normalise Logic is very clear and easy to follow Logic is clear and convincing Mostly consistent and logical Adequate cohesion and conviction Arguments are confused and disjointed Dependency All elements are present and very well integrated. Components present and well integrated Components present and mostly well integrated Most components present Representation lacks structure. ER Diagram Extremely good effort. All elements are present and very well integrated. Outstanding Good effort. Most components are present and well integrated Good effort made but not outstanding Made some effort with inaccuracies Very little attempt. Lazy effort with inaccuracies

len2122829

9/26/2018 12:24:29 AM

Example Marking Rubric for Assignment 2Report:Total Marks 70 for the report Grade Mark HD 100% DISTINCTION 80% CREDIT 60% PASS 40% Fail 0-40% User Views as Tables Ability to think critically and analysed clearly Relevant and soundly analysed. Generally relevant and analysed. Some relevance and briefly presented. Not relevant to the assignment question. Relationships Demonstrated excellent ability to think critically and identifiedrelationships Demonstrated good ability to think critically and identified relationships. Demonstrated ability to think critically and identify some relationships Demonstrated some ability to think critically. Did not demonstrate ability to think critically

len2122829

9/26/2018 12:24:23 AM

2. ER Diagram Represent the structure of your database visually by using the ER diagram.Evaluate your proposed solutions 15 3.Model building Model building on MS SQL Server 10 4. Report Generation Example report 5 Totalmarks or the Report 70 Assignment 2 Quiz marks Marks for Assignment 2 Quiz 30 TOTAL 100

len2122829

9/26/2018 12:24:16 AM

Marking criteria: Example of marking criteria is shown in the following table. Marks are allocated as follows: Section to be included in the report Description of the section Marks 1. a. Identify all entities Identify entitiesinall user requirements 5 b. User Views as Tables Represent the User Views as a collection of Tables 10 c. Relationships Determine the relationships between entities 5 d. Functional dependences. DetermineFunctional dependences. 10 e. Normalise tables Analyse above tables and normalise these 10

len2122829

9/26/2018 12:23:59 AM

Description of this assignment: This assignment consists of two parts: Part A: An online quiz Assignment 2, which includes 30 questions. Students may have 3 attempts at this quiz. The system will select the highest grade. Part B: The creation of an ER diagram and implementation Submission Guidelines • All work must be submitted on Moodle by the due date. Write your answers in this document underneath the question and save as _your_name.doc”. • The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2.5 cm margins on all four sides of your page with appropriate section headings. • Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using IEEE referencing style. • Submit both the database that you created and the word document.

Write a Review

Required(*) Message

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!

Submit Assignment

User Account

All Pages