ASSIGNMENT
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
