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