Create a database to keep track of all the courses

Assignment Help Database Management System

Reference no: EM131802381

Question: 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: EM131802381

Questions Cloud

What challenges do the global hrl practitioners face : What challenges do the global HRL practitioners face?

How the element would be measured or evaluated : Please pay attention to the questions asked. Proper English and original paper. Ensure all the areas are answered with subtopics so that the paper flow.

What amount of interest should cole capitalize : Cole Co. began constructing a building for its own use in January 2011. What amount of interest should Cole capitalize

What is the purpose of business : 1. What is the purpose of business? 2. As business leaders, what do you see as your purpose and role in society?

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

Prepare a diagram with snap inc as the central organisation : Prepare a diagram with Snap Inc. as the central organisation surrounded by the company's stakeholder groups using the stakeholder view model.

Hr management and gig economy : This question is on workplace, HR management and 'gig economy.' Companies set working conditions, pay scales, training, and strive for stability.

Warranties with the bananas he shipped to george michael : Did Jorge Miguel breach any warranties with the bananas he shipped to George Michael?

What is the third phase in audit plan : What is the third phase in audit plan and how do I do it for a not for profit organization.

User Account

All Pages