Instructions: 

1) You must upload the database name in this format

     INFO261_WK2_{yourlastname}.accdb.

2) Make sure that you review Chapter 2 from the text book. 

3) I encourage you to search the Internet for additional information.

 

Assignment:

You are going to build tables for the following:

You are about to model a small education institute with the following specs

there are 5 instructors, 8 courses, 3 classrooms, and 40 students

The relationships between them as follows;

Each instructor has one or more courses, each course will be taught in one or more classroom, each classroom will have one or more students, you need to relate the tables using primary/ foreign keys.

Insert all required records (5 instructors, 8 courses, 3 classrooms, and 40 students)

in each table to demonstrate the relationships, also the student can take more than one course

*** Rules

1) You must enter your name as one of the instructors

2) Each course is taught once a week for 8 weeks

 

MY TEACHER SAID THAT I NEED ONE-TO-MANY RELATIONSHIPS

SophiaPretty

(5)

Status NEW Posted 05 Dec 2017 05:12 AM My Price 6.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer