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 |