ERD Data base
Section-B – Prepare ERD and RDM for following Scenarios
Students and Subjects Scenario
STUDENT
|
StudentId |
Name |
Course |
BirthDate |
|
100 |
Jones |
Arts |
21/03/85 |
|
150 |
Parks |
Accounting |
19/06/85 |
|
200 |
Baker |
Mathematics |
04/04/85 |
|
250 |
Glass |
Arts |
14/09/85 |
|
300 |
Baker |
Accounting |
19/07/85 |
|
350 |
Russell |
Mathematics |
20/07/85 |
|
400 |
Rye |
Accounting |
18/03/85 |
|
450 |
Jones |
Arts |
24/12/84 |
ENROLMENT
|
StudentId |
SubjectCode |
Position in class |
|
100 |
BD445 |
1 |
|
150 |
BA200 |
1 |
|
200 |
BD445 |
2 |
|
200 |
CS250 |
1 |
|
300 |
CS150 |
1 |
|
400 |
BA200 |
2 |
|
400 |
BF410 |
1 |
|
400 |
CS250 |
1 |
|
450 |
BA200 |
3 |
SUBJECT
|
SubjectCode |
SubjectTitle |
Lecturer |
|
BA200 |
Accounting for Beginners |
Back |
|
BD445 |
Economics for Experts |
Doyle |
|
BF410 |
Finance for Wizards |
East |
|
CS150 |
Introductory Computing |
Davies |
|
CS250 |
Advanced Programming |
Hallam |
Cafe Menu Scenario
TABLE
|
TableId |
NumberOfPlaces |
|
1 |
4 |
|
2 |
8 |
|
3 |
2 |
MENU
|
DishNumber |
NameOfDish |
Price |
|
31 |
Grilled Salmon |
$23.95 |
|
32 |
Smoked Trout |
$25.95 |
|
33 |
Crab Salad |
$26.50 |
WAITER
|
WaiterId |
Name |
Phone |
|
1005 |
Sasha |
63323232 |
|
1006 |
Julie |
63258251 |
|
1007 |
Samantha |
63636363 |
ORDER
|
OrderId |
TableId |
WaiterId |
StartTime |
NumberInParty |
|
99124 |
1 |
1005 |
1830 |
3 |
|
99125 |
2 |
1006 |
1900 |
6 |
|
99126 |
3 |
1005 |
1905 |
2 |
|
99127 |
1 |
1006 |
2030 |
4 |
ORDER_LINE
|
OrderId |
DishNumber |
Quantity |
|
99124 |
31 |
2 |
|
99124 |
33 |
1 |
|
99125 |
32 |
3 |
|
99125 |
33 |
2 |
