database system 8

Create a empty database in SQL server.

In the folder databases right click, new database.

Create the ER and database diagram.

Write the sql code to create the tables of your database diagram with the PK and FK .

Run the sql code in yoursqlserver to create the tables

Insert data in the tables.

Write the process of normalizing all the tables.

Write the data as if you only have one big table. That is the redundancy file.

Backup the sql database into a file in the disk

Zip all the documents ( ER,database model, normalization file, redundancy file and the backup file