Ask Question, Ask an Expert

+61-413 786 465

Ask DBMS Expert

Home >> DBMS

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).

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

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M93110295
  • Price:- $100

Guranteed 48 Hours Delivery, In Price:- $100

Have any Question? 

Related Questions in DBMS

Question create an erd for the following scenario once you

Question: Create an ERD for the following scenario. Once you submit you will get access to the correct way to create the ERD. Please watch the video and correct any errors in your submission and resubmit. A small company ...

Databases assignment - monash library services monlib case

Databases Assignment - Monash Library Services (MonLib) Case Study TASK 1: Data Definition For this task you are required to complete the following: 1.1 - Add to your solutions script, the CREATE TABLE and CONSTRAINT def ...

This assignment is a continuation of this solution the case

This assignment is a continuation of this solution The case study company has received the first report from its enterprise content management (ECM) consultant and now has a documented list of major content requirements ...

Real time analytics - data analytics assignment -this is a

Real Time Analytics - Data Analytics Assignment - This is a business analytics project aimed at generating innovative analytics solutions for a Global Food Consulting firm working in the area of Animal agriculture and fa ...

Stored procedure please create the following stored

Stored procedure. Please create the following stored routines using CPS3740_2017S database using the tables in dreamhome database. xxxx is your email id 1) Implement a stored procedure p3Q21_xxxx to display the Branch ci ...

Database and information retrieval assignment - data

Database and Information Retrieval Assignment - Data Privacy Essay Task - Write an essay (aim for 750 words) that addresses issues associated with data proivacy. Use the Australian Privacy Principles - discussed in class ...

In sql database questions phase-1 in 100 words what steps

In SQL Database Questions: Phase-1 In 100 words, what steps can one take to avoid losing work? Which command is used to save changes to the database? What is the syntax for this command? Phase-2 In 100 words, explain the ...

Quesiton 1 what is data-manipulation language dml there are

Quesiton: 1. What is Data-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last ...

Sql injection on a searchthe way search performs its task

SQL injection on a search The way Search performs its task is by executing the following query (in a php script):          $var=stripslashes($_POST['search']);          $query = "SELECT username from lab1_login where use ...

Students will select a situation or problem from their

Students will select a situation or problem from their company as a course project that can be solved using a database system. Using MS Access, or MS SQL Server Express, students will create a relational database model o ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As