CS403 Assigment 2 2023
#Vu #cs403
CS403 Assigment 2 2023
Task 1:
Write SQL statement to create a new database in SQL Server by your VU ID (sample screenshot is provided on the last page of this file).
Task 2:
Write SQL statements for the following:
• Create tables: Stadium, MatchSchedule and Block in database created in Task 1.
• For each table, you have to define all attributes/columns given in ERD with appropriate data types.
• You are also required to define Primary key of each table.
• Transform multi-valued attribute.
• Map all relationships and add foreign keys in appropriate tables according to relationships types.