Create data types for attributes. Remember that your COURSE_ID should be alphanumeric or VARCHAR (not numeric). You

Fantastic news! We've Found the answer you've been seeking!

Question:

Create data types for attributes. Remember that your COURSE_ID should be alphanumeric or VARCHAR (not numeric). You must use primary and foreign keys in your Data Definition Language (DDL) to create table statements. Do not plagiarize this assignment. Any teams creating non-unique SQL code from sources other than your own will receive a 0 for this assignment. It is very easy for me to know if the assignment was compromised.

The structures should contain the attributes specified in the ERD. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD. (You will lose points for not enforcing referential integrity).

only implement the following relationships on the diagram:

A SCHOOL Operates 1:M DEPARTMENTS
A DEPARTMENT has 1:M STUDENTS
A STUDENT has 1:M ENROLL
A CLASS is found in 1:M ENROLL
A COURSE generates 1:M CLASS
A BUILDING contains 1:M ROOMS
A ROOM is used for 1:M CLASSES
A PROFESSOR teaches 1:M CLASSES
A SEMESTER includes 1:m CLASSES

Deliverables

ERD diagram created using the SQL CREATE statement that is executable in MS-ACCESS Save each SQL statement with a self-documenting name such as CREATE_TABLE_PROFESSOR, CREATE_TABLE_COURSE. You must submit the database with the saved queries.
Unique distinct data types for each attribute in your tables. Hint: No one designs a table the same therefore your design should not be like any other database on the internet or the publisher. You cannot use pre-created SQL statements. You must create your own! If you have trouble creating your tables using SQL (DDL) then create your tables manually. Manually created tables will lose points however this will allow you to continue your project.