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
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post erd-data-base appeared first on Essay Fount.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
