Question: create schema for each table ensure that all fieldsattributes are...
- Create schema for each table. Ensure that all fields/attributes are listed and the primary key is clearly underlined. Identify foreign keys where applicable. Below is a template of the schema.
Please follow the example below:
TableName(PrimaryKey ̧ attribute1, attribute2, ..., attributeM, refAttribute1, ... refAttributeN) where refAttribute1, ..., refAttributeN are foreign keys
- Use MS Access to create the tables for the Our Pound Pet Adoption systems. For the submission, you need to provide screen captures that clearly shows the tables and their attributes, as well as the relationship. Please see example below from your lab works.
- Use MS Access to create the input screen that can be used as entry point for animals and clients details to the database. For the submission, you need to provide screen captures that clearly shows the input form