info system for managers home work

profilebostonguy90

Create a Database from blank (scratch) for a manager and name it. Create and design a table and name it.  For each fields click and choose proper a data type such as short text and name the field. Make at least three fields. Enter your records.  Make sure to add your name as a record. (3 tablesx20=60 points).

Similarly create two more tables. 

By design tool, make a relationship between each of two tables at a time and drag a primary key one table to a secondary key of another table. For example one to one, one to many, many to one or many to many)  2 relationshipsx10=20 points 

Run at least 5 queries of different important tasks on the data base  (5queriesx4=20 points)

Example to walk you through can be found in the class notes.


FOLLOW ALL DIRECTIONS STEP BT STEP

  • 4 years ago
  • 22
Answer(1)

Purchase the answer to view it

blurred-text
  • attachment
    Manager.accdb
  • attachment
    Infosystemformanager.docx