ASSIGNMENT $1$: CREATING THE DATABASE DESIGN

In this avilument, yoa dealen your datahase tables tuint a worl$-$procesint prodram. Pay close attention to the hegle and structure of the tahles. Do not start deweping your Acces database in Awigument $2$ belore getting fecdhack from your instructor on Assignment $1.$ Keep in mind that you need to examine the requirements in Asulgnment $2$ to design your fields and tahks properly. It is good programming prictice to look at the required outputs tefore beginning your design. When designing the datahase, oherve the following cuidelines:

Ans, determine the tables you will noed by listine the name of each talle and the fichls it should contain. Awold data rodundancy. Do not create a field if it can be created by a calculated feld in a guery.

You will need a transaction take. Think about the business event that oceurs with each ehilds. redistration. Keep in mind that some children sien up for multiple classes. Avoid duplicating data.

Document your tables using the talle feature of your word procesone. Your tables should resem. He the format shown in neure $2-1.$

Vou nust mark the appropriate key fidd$($s$)$ by entering an asterisk $(")$ next to the field nyfie. Kexp in mind that some tables milht need a compound primary key to uniquely identify trecord within a table.

Irint the database design.