a. Create tables that a company such as this might use (i.e. Equipment, Employees, One-time customers etc.)
• Create and Name Tables (Just headers for the tables, no need to fill them in)
• Explain what each box/field will represent, how it is formatted (i.e. this field is going to hold text only/ 10 characters, date, numbers, Boolean: T/F, etc.)
b. This section needs to be in MEAL format
• Answering yes she can or no she can’t and find 2 sources to back your stance
• The “Link” sentence needs to to primary keys and foreign keys
c. Draw picture with primary key and foreign key
Sample Solution
