Reference no: EM131278250
Dick Scudder, the chairperson of the information technology department at the University of Denver, needs to create a database to keep track of all the courses offered by the depart- ment. In addition, Dick would like the database to include each instructor’s basic contact information, such as ID number, name, office location, and phone number. Currently, Dick has nine instructors (seven full-time faculty members and two adjuncts) in the department.
For each course, Dick 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.
Finally, Dick 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 re- ceives in each course.
Dick has asked you to create an ERD from the information described above, and then create a normalization structure in 3NF.
|
Generate the master production schedule
: Generate the Master Production Schedule for this product at your facility. You have 40 items in your beginning inventory. The Lot Size is to be in multiples of 39. October November Week 1 2 3 4 5 6 7 8 Forecast 30 35 38 41 40 40 40 20 Customer orders..
|
|
What is the optimal order size in bags
: PBK uses 50 bags of whole bean coffee every month, assume demand is steady throughout year. PBK has signed contract to purchase coffee from Phis Roasters for price of $25 per bag and $85 fixed cost for every delivery independent of the order size. Wh..
|
|
Determine the probability of burning out in these intervals
: The estimated service life of a halogen headlight is normally distributed with a mean of 500 hours and a standard deviation of 40 hours. Determine the probability of burning out in these intervals:
|
|
Primary sources of information on a given countrys culture
: Under what circumstances should international business people impose the values of their culture on foreigners with whom they do business? What are two primary sources of information on a given country’s culture? Outline why the culture of a country ..
|
|
Chairperson of the information technology department
: Dick Scudder, the chairperson of the information technology department at the University of Denver, needs to create a database to keep track of all the courses offered by the depart- ment. In addition, Dick would like the database to include each ins..
|
|
Multidomestic strategy-global strategy-transnational strate
: Assume you are in charge of developing a strategy for a multinational company selling products in many different countries around the world. Multidomestic strategy. Global strategy. Transnational strategy
|
|
Process is in control and centered at nominal
: A process is in control and centered at nominal. Output from the process is normally distributed and the process capability index, Cp, equals 1.02. Determine the expected number of nonconforming units that will result from a production run of 20,000 ..
|
|
The mean time between failures for a watch battery
: The mean time between failures (MTBF) for a watch battery is 36 months. Determine the following probabilities: a) the probability of failure before 36 months. b) The probability that a system which is composed of two such solenoids will fail within 3..
|
|
Assume the actual value and forecast value
: Actual demands for the last four months are as follows. What are the forecast values for March, April, May, June and July based on exponential smoothing method with Alpha = 0.2? Assume the actual value and forecast value for March are the same.
|