CS 2203 Programming 1 (5)

docx

School

University of the People *

*We aren’t endorsed by this school

Course

2203

Subject

Computer Science

Date

Feb 20, 2024

Type

docx

Pages

4

Uploaded by Iby007

Report
No Entity set 1. DOCTOR 2. PATIENT 3. APPOINTMENT Programming Assignment Unit 1 University of the People CS 2203 Databases 1 Rich Hoo, Instructor June 22, 2022
The entities are as follows. SN Entity Set 1 Doctor 2 Patient 3 Appointment Doctor Relation Attribute Name Type Domain Optional/Constraint Doc. ID Unique identifier Numeric No / Unique constraint/ Entity integrity constraint Name Composite Attribute Text No/ Null constraint Phone Multi-valued attribute Numeric No /Null constraint Specialty number Single-valued attribute Text No/Null constraint Specialty Multi-valued attribute Text No/ Null constraint Primary key: Doc. ID Degree of relation : 5 Candidate keys : Name, Phone Name, Phone, Specialty Number Patient Relation Attribute Name Type Domain Optional /Constraint Patient ID Unique identifier Numeric No / Unique constraint/ Entity integrity constraint Name Composite attribute Text No/ Null constraint phone Multi-valued attribute Numeric No /Null constraint
Email Single-valued attribute Text No/Null constraint Address Composite attribute Text No/ Null constraint Added date Single-valued attribute Text No /Null constraint Allergies Multi-valued attribute Text No/Null constraint Doctor Identifier Multi-valued attribute Numeric No / Referential integrity constraint Primary key : Patient ID Degree of relation : 8 Candidate keys : Name, Phone, Address Appointment Relation Attribute Name Type Domain Optional / Constraint Appointment ID Unique identifier Numeric No/ Unique Constraint / Entity Integrity Constraint Appointment Date Single-valued attribute Numeric No/Null Constraint Doctor id Single attribute Numeric No/Referential Integrity Constraint Patient id Single attribute Numeric No/ Referential Integrity Constraint Blood Pressure Single-valued attribute Numeric No/ Null Constraint Pulse Single-valued attribute Numeric No/ Null Constraint Treatment Notes Single attribute Text No/ Null Constraint Medicines Multi-valued attributes Text No / Null Constraint Degree of relation is 8 Primary key: Appointment ID Candidate keys : Doctor id, Patient id, Appointment ID
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Reference Sharma, N., Perniu, L., Chong, R. F., Iyer, A., Nandan, C., Mitea, A. C., Nonvinkere, M. & Danubianu, M. (2010).  Database fundamentals . IBM Canada. https://my.uopeople.edu/pluginfile.php/1587506/mod_book/chapter/347448/ Database_Fundamentals.pdf

Related Documents

sp21final.pdf
Quiz 1.docx
IST 7040 Week 1 Discussion.docx
NeuralNet_report.pdf
Homework 1.pdf
Tutorial01_Case4_Rubric.docx
sample_midterm cs mcq.pdf
fire prevention essay.docx
Course Hero Logo.docx
module 2 short responses.docx
CS330-project proposal.docx
tutorial3.docx
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS