Create a database to keep track of all the courses

Assignment Help Business Management

Reference no: EM132536259

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 the department offers. 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: EM132536259

Questions Cloud

What is the average cost per five-day week : If the average salesperson sells seven cars per day, what is the average cost per 5-day week for detailing cars? (Do not round intermediate calculations.)

What was the force from the ground on bolt : If his mass was 86 kg at the time of the race, what was his force at t = 0 seconds. What was the force from the ground on Bolt at t = 0 seconds?

List three aspects of the simulations that surprised : List three aspects of the simulations that surprised you, intrigued you, confused you, or otherwise piqued your interest.

Find unit cost for each product use activity-based costing : Hakara Company,Use activity-based costing to determine a unit cost for each product. (Round your final answers to 2 decimal places.)

Create a database to keep track of all the courses : 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

Write a paragraph or two about his biography : Do a little research and write a paragraph or two about his biography and why he is an important Jewish writer. The heart of the paper is a discussion.

What are principles you have personally learned : What are the principles you have personally learned in course that have impacted or will impact your leadership in your workplace, home, church, and community

Write the equation for the regression line : Write the equation for the regression line using the information from the regression output. Using that equation, predict the value of a home

Why company use process cost vs project cost accounting : Why would a company use process cost vs. project cost accounting? How do the two methods differ in terms of accounting for the flow of costs?

User Account

All Pages