Transcript Lecture - almdares.net

<CourseName>
Tutorial 3
Resources
8th - 10th August 2006
Ministry of Higher Education: Oman
Review Forms Analysis
CUSTOMER
VEHICLE
VEHICLE
TYPE
RENTAL
Cus tomer
Cust ID
<pi> <M>
Surname
<M>
First Name
<M>
Address
<M>
City
<M>
Phone 1
<M>
Phone 2
Rental
rent
rented by
Rental ID <pi> <M>
Rent Date
<M>
Due Date
<M>
Reminded
assigned to
assigned
V ehic le
Reg Num <pi> <M>
classification for
of
V ehic le Type
Vech Type ID <pi> <M>
Description
<M>
Entities
1. Artwork
2. Artist
3. Gallery
4. Staff
5. Loan header
6. Loan detail
Example Business Rules
1. Every artwork must be of a certain type
2. Multiple artworks can be registered for a
3.
4.
5.
6.
particular artist
All new galleries requesting artworks must
have their name and contact details on record
Artworks can be returned on different days
Artworks can be loaned at different amounts
Every loan transaction must be administered
by one staff member
Loan Report
Overdue Report
Artist
Artist ID
<pi> <M>
First Name
<M>
Surname
<M>
Street Address
<M>
Suburb
City
<M>
Phone
<M>
Email
Artwork
Artwork Code <pi> <M>
Title
<M>
Year
<M>
Charge
<M>
Artwork Type
Artwork Type Code <pi> <M>
Description
<M>
Loan Detail
Due Date
<M>
Return Date
Loan Charge <M>
Staff
Staff Num
<pi> <M>
First Name
<M>
Surname
<M>
Street Address
<M>
Suburb
City
<M>
Phone
<M>
Email
Gallery
Loan Header
Loan Num <pi> <M>
Loan Date
<M>
Gallery ID
<pi> <M>
Name
<M>
Street Address
<M>
Suburb
City
<M>
Phone
<M>
Email