Create the following table in SQL. ModuleID Attribute ModuleID ModuleName Table: Module Credit TuterD ModuleName The...

     

Transcribed Image Text:

Create the following table in SQL. ModuleID Attribute ModuleID ModuleName Table: Module Credit TuterD ModuleName The types for each attribute for the MODULE relations are given below: Data Size Constraint Key Type Not Null Primary key Not Null Data Type Character string 7 Character string 8 Integer Character string 9 Credit TutorID Once the table is created, populate it with a least 5 rows of data. Make sure the integrity constraints are not violated. Create the following table in SQL. Table: Student StudentID Name Age Address Sex FeeStatue Character string 9 Character string 20 Integer Character string 100 Character string 1 Character string 10 The types for each attribute for the Student relations are given below: Attribute Data Type Data Size Constraint Key Type Not Null StudentID Primary key Name Not Null Age Address Sex FeeStatus Once the table is created, populate it with a least 5 rows of data. Make sure the integrity constraints are not violated. Create the following table in SQL. StudentID Table: Grade ModuleID ModuleID Character string StudentID Character 9 string Grade Integer The types for each attribute for the grade relations are given below: Attribute Data Type Data Constraint Key Key Type Size 7 Not Null Primary Foreign Key to Module table Foreign Key to Primary Student table Grade Not Null Once the table is created, populate it with a least 5 rows of data. Make sure the integrity constraints are not violated. Create the following table in SQL. ModuleID Attribute ModuleID ModuleName Table: Module Credit TuterD ModuleName The types for each attribute for the MODULE relations are given below: Data Size Constraint Key Type Not Null Primary key Not Null Data Type Character string 7 Character string 8 Integer Character string 9 Credit TutorID Once the table is created, populate it with a least 5 rows of data. Make sure the integrity constraints are not violated. Create the following table in SQL. Table: Student StudentID Name Age Address Sex FeeStatue Character string 9 Character string 20 Integer Character string 100 Character string 1 Character string 10 The types for each attribute for the Student relations are given below: Attribute Data Type Data Size Constraint Key Type Not Null StudentID Primary key Name Not Null Age Address Sex FeeStatus Once the table is created, populate it with a least 5 rows of data. Make sure the integrity constraints are not violated. Create the following table in SQL. StudentID Table: Grade ModuleID ModuleID Character string StudentID Character 9 string Grade Integer The types for each attribute for the grade relations are given below: Attribute Data Type Data Constraint Key Key Type Size 7 Not Null Primary Foreign Key to Module table Foreign Key to Primary Student table Grade Not Null Once the table is created, populate it with a least 5 rows of data. Make sure the integrity constraints are not violated.

Answer rating: 100% (QA)

To create the tables in an SQL database according to the specifications provided in the images you need to use SQL CREATE TABLE statements and enforce ... View the full answer