Student

StudentId	FulName	Email	School	Major	StudentType	EndrollmentDate
A00121	John, Doe	doej01@school.com	Clark	Economics	Undergraduate	1/5/2019
A00462	Jane, Doe	doej02@school.com	Clark	Business	Graduate	1/5/2019
A00445	John, Doe	doej03@school.com	Clark	Business	post-graduate	1/5/2018

QuizBank

Topic	QuestionCode	QuestionText	Answers	CorrectAnswers
Math	Q001	1+1	0;1;2;4	C
Math	Q002	1+2	0;1;2;3	D
Math	Q003	SQRT(4)	-2;0;2;4	A;C
Math	Q004	1+3	0;1;2;4	D

Quiz

Email	Quiz	QuizTakenDate	Question	Answers
doej01@school.com	Quiz1	1/30/2024	Q001	A
doej01@school.com	Quiz1	1/30/2024	Q002	B;C
doej02@school.com	Quiz2	1/30/2024	Q002	D
doej02@school.com	Quiz2	1/30/2024	Q003	B

Use model and tables above to normalize data to 3NF. Create physical data model for SQL server using database diagrams.

1.Create new database

2.Create new schema or use dbo

3.Create diagram

4.Create DDL statement for all normalized tables, with primary and foreign keys

5.Demonstrate example of

1.Unique key

2.Default value

3.NOT NULL

4.Check constraint

Submit Screenshot of the diagram in the SQL Server for all the tables in the requirement

Submit SQL script with table DDL for all the physical tables.