logo

DATABASE DESIGNING.

5 Pages449 Words68 Views
   

Added on  2022-11-18

About This Document

Design a database schema for the proposed Database Design Proposal in Module 1. Identify and list all relevant entities and their relationships: 1) Select no less than five entities. 2) Provide a diagram. 3) Map this to a database schema. 4) Provide a data dictionary for all entity attributes. Focus on one or two areas of your design that seemed especially difficult to develop and provide a brief assessment of the difficulty you encountered in modeling or mapping to the schema. In addition, provide the rationale for the design chosen, its limitations, and its possible extensions. Tip: If you do not have access to ER modeling software or a diagramming tool like Visio or OmniGraffle, you can simply create diagrams in a presentation tool like PowerPoint. This is an essential skill which is used in the field. APA format is not required, but solid academic writing is expected. This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; ther

DATABASE DESIGNING.

   Added on 2022-11-18

ShareRelated Documents
Running head: DATABASE DESIGNING
Database Design
Name of the Student:
Name of the University:
Author note
DATABASE DESIGNING._1
1
DATABASE DESIGN
ER Diagram
Database schema
Administrator (AdminID (pk), AdminName, AdminAddress)
Staffs (StaffID (pk), StaffName, Contact, Fax, Email)
Medicines (MedID (pk), MedName, Composition)
Disease (DiseaseID (pk), DiseaseName)
Patients (PatientID (fk), PatientName, Age)
Diagnosis (DiagnosisID (pk), StaffID (fk), DiseaseID (fk), PatientID (fk))
Prescribed Dose (DoseID (pk), PatientID (fk), DiagnosisID (fk), MedID (fk), DoseDetails,
AdminID (fk))
Alert (AlertID (pk), DoseID (fk), StaffID (fk), Intervals)
DATABASE DESIGNING._2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design and Development
|32
|2899
|1

Nursing Infromatics Question Answer 2022
|12
|1832
|10

Database Discussion 2022
|19
|2743
|13

NIT1201 Database Management System Assignment (DBMS)
|20
|2180
|351

Database Design for Tennis Tournament System
|38
|4041
|355

H16W 35 Relational Database Management Systems
|16
|1641
|138