MN405 Data and Information Management Assessment and Tutor Proposal

gif-final

Order Now mail

MIT


Individual assignment

Assessment No: 1

MN405|Data and Information Management

Our Real
uni-icon
Student’s Score cards


MN405 Data and Information Management  Assessment and Tutor Proposal

MN405 | Data and Information Management | Assessment 2


Task

Assignment Description

Complete the information-level design for a database that satisfies the following constraints and user view requirements.  Knox private hospital contracted with GreenIT services to develop and design their hospital database, the hospital IT Manager provided the following business rules to the GreenIT services software developer: Complete the information-level design for the database that satisfies the following constraints and user view requirements. In order to complete, the information-level design you are required to answer the questions given below (a) – (e). 

User view 1 requirements / business rules:

Note: Write down any assumptions you make, if they are not explicitly described here in user requirements.

Answer the questions given below: (a) – (e)

  • Patients are identified by a PatientID, and their names, addresses, and ages must be recorded.

User view 2 requirements / business rules:

  • Doctors are identified by a DoctorID.
  • For each doctor, the name, specialty, and years of experience must be recorded.

User view 3 requirements / business rules:

  • Every patient has a primary physician/doctor. Every doctor has at least one patient.

User view 4 requirements / business rules:

  • 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 requirements / business rules:

  • For each drug, identified by DrugID and the trade name and formula must be recorded.

User view 6 requirements / business rules:

  • 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 requirements / business rules:

Each pharmacy has a unique name, address, and phone number.

Note: Write down any assumptions you make, if they are not explicitly described here in user requirements.

Answer the questions given below: (a) – (e)

  • Analyse all user requirements given above and identify and list entities described in these user requirements.
  • Add attributes to these entities and represent them as a collection of tables and attributes (Database schema):
    e.g. Patient (Patient_ID, P_name,…….)
    Note: Select and underline suitable primary key for each table.
  • Outline 3 business rules that describe the relationships between entities.
    Note: You can make assumptions to create certain relationships, if it is not specifically mentioned in the given business rules.
    Every doctor has at least one patient -- One-to-many
  • Determine the functional dependences.
    e.g. Patient_ID àname, address, ......
  • Then normalise these tables. Make the normalization to 3NF. State for every step in the normalization, which functional dependency causes it.

Represent the structure of your database visually by using an entity-relationship (E-R) diagram.

If you make any assumptions about data that are not explicitly given in the problem, these must be described.

Note: You need to use Visio, draw.io [1] or Lucid chart [2] or any other software tool, to create the ER diagram.

Model building

  • Build this model using MS Access/ SQLite by creating these tables and Relationships.
  • Populate these tables with appropriate data; include at least 2 records in each table. Include the following in your MS Word document.
    • If you are using MS Access include following screen shots
      • Relationship diagram created in Access. (Select database tools àRelationships in the Access menu)
      • Data sheet view and design view of your tables.
    • If you are using SQLite
      • Screen shots of CREATE TABLE command and you can use INSERT INTO commands to add records.

Report Generation

  • Write an SQL query to generate one example of useful information that can be obtained from this database.
  • For additional 5 marks, you need to write and execute at least 2 more SQL queries on the database you have created in Question 3 and include the screen shots of the outputs and all SQL statements.

Bibliography

Why invest in our services?

Only High Quality
Optimum quality

Our assignment help team is trained to provide you high quality writing services.

Reasonable Price of Each
High scores

High scores achieved by our students is a portrayal of our high quality online assignment help

Privacy and Security
Multiple reach

You can place your assignment order through 4 easy modes of communication

Order Now

TUTOR PURPOSAL


Here is how, we will write your assignment

tutor-proposal

We write your assignment in the following proposed way and we make sure that it is strictly in accordance to your assignment guidelines and each section of the assignment is written with respect to its marking criteria/ rubric.

TUTOR PROPOSAL FOR : MN405|Individual assignment

liMN405 Data and Information Management