Final Project CS4420 Database
Create the E/R model of the database you are going to build. The more variety the better grade.
• Scan the diagram in a file or build the diagram in word or other text processing program.
• Create the database model in another file and keep it.
• Normalize all the tables to the BoyceCodd Normal form and explain the process .
• Create a database called Last Name LastName2.
• Create the tables in the SQL Server program with SQL commands.
• Create the diagram of the database Model in SQL Server.
• Insert an average of 10 records per table as long as the model allows it.
• Try to retrieve data from the database.
• Include the original info. In other words, how the data would look if no
