1. Engineering
  2. Computer Science
  3. create schema for each table ensure that all fieldsattributes are...

Question: create schema for each table ensure that all fieldsattributes are...

Question details

Screen Shot 2020-10-03 at 6.15.11 pm.png

  1. 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

 

  1. 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. 

Screen Shot 2020-10-03 at 6.16.29 pm.png

  1. 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 
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution