Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. Write the SQL statements that create the Student Enrollment Database as described in the following table Allow Table Null Remarks No PK No No

image text in transcribed
image text in transcribed
. Write the SQL statements that create the Student Enrollment Database as described in the following table Allow Table Null Remarks No PK No No No No PK No No No Yes No PK No No No PK No No No No No No No No PK No Yes No Yes No Column Name Data Type Character Character Integer Character Character Character Integer Inte Character Inte Size COURSE NUM COURSE TITLE CREDIT HR DEP COD Fixed 8 Up to 40 Course Fixed S Fixed 5 Up to 40 FK Department DEP CODE DEP NAME ST ID FK FK Enrollment CRN GRADE INSTRUCTOR ID Fixed 2 Instructor INSTRUCTOR NAME Character Up to 30 DEP CODE CRN COURSE NUM SEMESTER INSTRUCTOR ID MAX ENROLLMENT ROOM DAYS TIME ST ID ST NAME ST GPA ST DOB ST ADDRESS DEP CODE FK Character Fixed 5 Inte Character Fixed 8 Character Fixed 15 Inte Inte Character Fixed 8 Character Fixed 4 Character Fixed 20 Integer Character Up to 30 Float Date Character Up to 50 Character Fixed 5 FK Offering Student FK 2. 3. Populate the tables you created in the first question with the data provided in the "Data.txt" file. Submit the SQL Server Database file, a text file with the SQL statements to create the tables, and a text file with the SQL statements to populate the tables

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions