Create database to keep track of all the courses offered

Assignment Help Operation Management

Reference no: EM131654103

The chairperson in the ISOM department at GMU needs to create a database to keep track of all the courses offered by the department. The database will also include information on each instructor’s basic contact information such as: ID number, name, office location, and phone number. For each course, the database will keep track of course ID, title, and number of credit hours. When courses are offered, the section of the course receives an ID number, and with that number, the department keeps track of which instructor is teaching the course. The chairperson would also like to keep track of the ISOM students. He wants to know which courses each student has taken. The information he would like to know about each student includes ID number, name, and phone number. He also needs to know what grade the student receives in each course (which can be determined from the section number).

An instructor can teach multiple sections.

A course contains multiple sections.

A student can be enrolled in multiple sections.

Reference no: EM131654103

Questions Cloud

Make generalizations about the country culture as whole : How would you describe India’s culture? Is it possible to make generalizations about the country’s culture as a whole?

Communication is to share progress-performance measurements : One important part of communication is to share progress and performance measurements with your stakeholder groups.

What are the enterprise profile and environmental factors : What are the enterprise profile and environmental factors in this project? What would the project management plan for this project be like?

Business plan for event management business in florida : Making business plan for event management business in florida.

Create database to keep track of all the courses offered : The chairperson in the ISOM department at GMU needs to create a database to keep track of all the courses offered by the department.

What are the main theoretical frameworks : What are the main theoretical frameworks and research strategies used to compare political institutions?

Explain the service and manufacturing process : Explain the service and manufacturing process.

About two flavors of budget reserves : In the discussion of contingency budgeting the PMBOK talks about two flavors of "budget reserves,"

How do these privacy protection features protect individuals : How do these privacy protection features protect individuals? Which does the best job of protecting privacy? why?

User Account

All Pages