Patient and Database Systems Guidelines
EE4791 Database Systems
Guidelines* for Tutorial 1
* Disclaimer: These are guidelines, rather than the actual solutions.
1. For each of the following pairs of entities indicate whether (under typical university circumstances) there is a one-to-many or a many-to-many relationship. Then using the shorthand notation introduced in the lecture, draw a diagram for each of the relationships.
a. STUDENT and COURSE (students register for courses)
Many-to-many (M:N)
STUDENT
COURSE
b. BOOK and BOOK COPY (books have copies)
One-to-many (1:N)
BOOK
BOOK COPY
c. COURSE and TUTORIAL (courses have tutorial sessions)
One-to-many (1:N)
COURSE
TUTORIAL
d. TUTORIAL and ROOM (tutorial sessions are scheduled in rooms)
One-to-many (1:N)
ROOM
TUTORIAL
e. INSTRUCTOR and COURSE
Many-to-many (M:N)
INSTRUCTOR
COURSE
Guidelines
p.1
EE4791 Database Systems
Guidelines* for Tutorial 1
* Disclaimer: These are guidelines, rather than the actual solutions.
2. Using the shorthand notation, draw a single diagram to represent the following situation. A BANK has one or more BRANCHes (a BRANCH always belongs to exactly one BANK). Each BRANCH may have one or more CUSTOMERs (but a CUSTOMER is assigned to only one BRANCH). Each CUSTOMER may own one or more ACCOUNTs, but each ACCOUNT is owned by only one
CUSTOMER. Also each CUSTOMER may submit one or more
TRANSACTIONs (but each TRANSACTION is submitted by only one
CUSTOMER). Finally, each ACCOUNT may have many TRANSACTIONs, and a TRANSACTION may be for more than one ACCOUNT.
BANK
BRANCH
ACCOUNT
CUSTOMER
TRANSACTION
Guidelines
p.2
EE4791 Database Systems
Guidelines* for Tutorial 1
* Disclaimer: These are guidelines, rather than the actual solutions.
3. Study the case of the Mountain View Community Hospital (see attached sheets). Then do the following exercises:
a. Case Question 5
Unstructured data:
• Medical scans (MRI, X-Ray, ECG, EEG, Ultrasound, etc)
•
Guidelines* for Tutorial 1
* Disclaimer: These are guidelines, rather than the actual solutions.
1. For each of the following pairs of entities indicate whether (under typical university circumstances) there is a one-to-many or a many-to-many relationship. Then using the shorthand notation introduced in the lecture, draw a diagram for each of the relationships.
a. STUDENT and COURSE (students register for courses)
Many-to-many (M:N)
STUDENT
COURSE
b. BOOK and BOOK COPY (books have copies)
One-to-many (1:N)
BOOK
BOOK COPY
c. COURSE and TUTORIAL (courses have tutorial sessions)
One-to-many (1:N)
COURSE
TUTORIAL
d. TUTORIAL and ROOM (tutorial sessions are scheduled in rooms)
One-to-many (1:N)
ROOM
TUTORIAL
e. INSTRUCTOR and COURSE
Many-to-many (M:N)
INSTRUCTOR
COURSE
Guidelines
p.1
EE4791 Database Systems
Guidelines* for Tutorial 1
* Disclaimer: These are guidelines, rather than the actual solutions.
2. Using the shorthand notation, draw a single diagram to represent the following situation. A BANK has one or more BRANCHes (a BRANCH always belongs to exactly one BANK). Each BRANCH may have one or more CUSTOMERs (but a CUSTOMER is assigned to only one BRANCH). Each CUSTOMER may own one or more ACCOUNTs, but each ACCOUNT is owned by only one
CUSTOMER. Also each CUSTOMER may submit one or more
TRANSACTIONs (but each TRANSACTION is submitted by only one
CUSTOMER). Finally, each ACCOUNT may have many TRANSACTIONs, and a TRANSACTION may be for more than one ACCOUNT.
BANK
BRANCH
ACCOUNT
CUSTOMER
TRANSACTION
Guidelines
p.2
EE4791 Database Systems
Guidelines* for Tutorial 1
* Disclaimer: These are guidelines, rather than the actual solutions.
3. Study the case of the Mountain View Community Hospital (see attached sheets). Then do the following exercises:
a. Case Question 5
Unstructured data:
• Medical scans (MRI, X-Ray, ECG, EEG, Ultrasound, etc)
•