Create one database and then write SQL statements to create all tables derived from the ERD given in Picture 1.1. Those tables have to locate under the database that you have just created with appropriate attributes, primary keys and foreign keys.
NOTE that when creating the SQL commands as request, you MUST keep the name of tables, relationship and attributes and data type of attributes as SAME as given in the above ERD.
Attributes have written with underline are Primary Key of each entity.
When submitting the responses for this question, submit only SQL statements for creating tables with corresponding keys and foreign keys. Do not use "create database" or "usedatabase_name" statements in your submission.
StudentID : int
Name:nvarchar(50)
Date:date
Attend
GroupID:char(6)
courseID:char(6)
Classes
NoCredits : int
Students
Address:nvarchar(200)
Gender:char(1)
Slot:int
Semester:char(10)
Attend : bit
Zoom
ClassID:int
year:int
+ 100%
Close
