A+first+database+design

Int 2
Think of a topic
 * On paper, design the table. It should have at least 6 fields and 20 records. Make sure that your design shows the data type of each field
 * Design a new layout for your table
 * Produce your table on the computer

Higher
Think of a topic. Try and think of something which can have 2 tables e.g. (Musician / album or Film / Director or Book / Author)
 * Decide on primary / foreign keys
 * On paper, design the tables. They should have at least 6 fields and 20 records. Make sure that your design shows the data type of each field
 * Design a new layout for your table
 * Produce your tables on the computer, making sure that you Define a relationship
 * Investigate adding a button to your table