following database diagram. Please, run the provided script to create tables and insert data into your database.
Locations
locationID
Name
Address
workFor
eventID
staffID
role
Events
eventID
name
StartTime
EndTime
locationID
Staffs
staffID
name
Phone
2 of 2
Paper No: 1
Question 1:
[2]Create one database and then write SQL statements to create, in this database, all tables derived from the ERD given in the following picture with appropriate attributes, primary keys and foreign keys.
NOTE that when creating the SQL commands as request, you MUST keep the name of
Close
+ 100%
Zoom