Question: Write SQL queries to create tables with keys and relations corresponding to each of the following question. NOTICE that when creating the SQL commands as

Write SQL queries to create tables with keys and relations corresponding to each of the following question. NOTICE that when creating the SQL commands as request, you MUST keep the name of tables, relationships, attributes and data type of attributes as SAME as given in the given ERD. Attributes have written with underline are Primary key of each entity. Attributes which reference to the primary key of another table must have the same name as the attributes in the primary key of the referencing table. When submitting the responses for this question, submit only SQL statements for creating tables with corresponding keys and foreign keys. No SQL statement specifying the database name like create database, alter database or use database.name is accepted. NbOfHours: int ExNumber: int Description: ntext Name: nvarchar(90) Section No: int Exercises Has Sections Percentage: float Mark: float Belong To Do Credits: int Students Courses Title: nvarchar(100) StudentCode: varchar(8) EullName: nvarchar(100) CourseCode: varchar(6)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
