Create an erd from the information

Assignment Help Business Management

Reference no: EM131376207

Course and Student Schedules Paul Bauer, the chair for the information technology (IT) department at the University of Denver, needs to create a database to keep track of all the courses offered by the department. In addition to the course information, Bauer would like the database to include each instructor's basic contact information, such as ID number, name, office location, and phone number. Currently, the department has nine instructors (seven full-time faculty and two adjuncts).

For each course, Bauer would like to keep track of the 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. There is only one instructor per course. Finally, Bauer needs to be able to keep track of the IT students and 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. He has asked you to create an ERD from the information described here using the Chen model.

Reference no: EM131376207

Questions Cloud

Company is soliciting ideas for its strategic plan : Suppose you work for the Wholesome Hamburger Company. You own a 100 fast food restaurants in California. There is a big drought and people are being told to use less water. You know that it takes: 1,800 gallons of water to produce one pound of beef, ..

Brief introduction of the company mobile marketing efforts : Evaluate the assumptions behind Burberry’s mobile marketing campaigns, with a brief introduction of the company mobile marketing efforts. Analyze the effectiveness of Burberry’s mobile marketing campaigns by applying relevant branding and promotion c..

Create an erd from the information described here : A particular event will use only one location, but a location may be used for multiple events. SportTech asks you to create an ERD from the information described here.

Create an erd from the information : 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. He has asked you to create an ERD from the information described here using ..

Enormous amount of money : Observing that Kodak is making an enormous amount of money from their film salesand the owners of Kodak are becoming very rich, the government imposes a tax of $0.50per roll of film.

Create an erd from information described using chen model : Each equipment type is associated with a single manufacturer that is referenced by a unique two-digit manufacturer ID number. You have been hired to assist Foothills Athletics to create an ERD from the information described here using the Chen mod..

Find a business continuity or disaster recovery article : Research on the general internet or in the University Library and find a Business Continuity or Disaster Recovery article online relating to records recovery, data (anything regarding to d/r and data - including data loss) OR workstations. Summari..

Construct the appropriate dummy variable : Since Gender is a categorical variable, construct the appropriate dummy variable in column E to indicate gender as female = 1 and male = 0. You must use an "IF" statement in the appropriate cell(s) to indicate the correct dummy value based on gen..

User Account

All Pages