Hi experts,
I’ve already started working on this assignment but need help only to finish it. I will attach the database file below and the assignment requires this:
This assignment must be an Access database that contains a minimum of 10 tables with 5 relationships, in 3rd normal form. Each table must have a minimum of 1 row of data. All column data types must be of the correct data type. All tables must have a valid primary key. Relationships must be between primary keys and foreign keys. No abbreviations allowed in table or column names. Naming conventions must be used consistently.
TIPS :
Relationships should be between a Primary key and a Foreign Key.
Example ID from the Author table to AuthorID in the Book table.
Tables need to be named appropriately. Names containing words like Table and Info are not acceptable.
Primary Keys should be AutoNumber in Microsoft Access.
Primary Keys should be named ID or TableNameID, for example BookID or AuthorID or just ID.
Relationships need to be between attributes/columns that are equal to each other, for example BookID from the Author table is equal to ID in the Book table.
Library_Branch is not related to Book_Location, as they are not equal.
Address is not an valid choice for a Primary Key.
Name is not an valid choice for a Primary Key.
Thank you!
0 comments