Question: The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the companys training

The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company’s training program. The HEG administrator gives you the description (see below) of the training group’s operating environment.

The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than ten trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes. Each class is taught by one instructor. Each instructor may teach up to two classes or may be assigned to do research only. Each trainee may take up to two classes per year.

Given that information, do the following:

a. Define all of the entities and relationships.

b. Describe the relationship between instructor and class in terms of connectivity, cardinality, and existence-dependence.

Step by Step Solution

★★★★★

3.46 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The HEG entities and relationships are shown in Table P45a Table P45a The Components of the HEG ERD ENTITY RELATIONSHIP CONNECTIVITY ENTITY INSTRUCTOR teaches 1M CLASS COURSE generates 1M CLASS CLAS... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

358-CS-DB (600).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

For the final project you will need you to create a spreadsheet /proforma of the cash flows from a property. There is no magic. All you have to do is layout the cash flows on a monthly basis. Then...

Describe the relationship between the two variables in the four plots. (b) (a) (d) (c)

You are required to create a conceptual data model of the data requirements for a company that specializes in IT training. The Company has 30 instructors and can handle up to 100 trainees per...

5. The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the companys training program. The HEG...

The Hudson Engineering Group ( HEG ) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company s training program. The HEG...

5. The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the companys training program. The HEG...

8. The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The HEG...

For each problem below, create a clear ERD showing the relationships (with verb like HAS, MANAGES, etc.), the cardinalities (1:1, 1:M, M:N), and whether the relation is optional or required. For M:N...

The goal of this assignment is to learn about ER Modelling. Please consider the following business rules: The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose...

Bandar Industries Berhad of Malaysia manufactures sporting equipment. One of the companys products, a football helmet for the North American market, requires a special plastic. During the quarter...

Suppose you are considering an investment that makes payments of $750 each year, for the next eight years. If you require a 7% return, what would you be willing to pay today?

Hampton Corporation has a beta of 1 . 0 3 and a marginal tax rate of 2 1 % . The expected return on the market is 1 9 % and the risk - free interest rate is 2 . 7 2 % . Estimate the firm s cost of...

Six - 15 (Comprehensive Case Covering Chapters 1 to 6) Personal Information Hillary Hawk has been divorced for some time and has sole custody of her two children, Mark and Mandy. Mark is 13 and Mandy...

Write a query to display the number of different patrons who have ever checked out a book (Figure P7.83). Figure P7.83 Different Patrons to Check Out a Book DIFFERENT PATRONS 33

Write a query to display the lowest book cost in the system (Figure P7.82). Figure P7.82 Least Expensive Book Price Least Expensive 49.95

Write a query to display the highest book cost in the system (Figure P7.81). Figure P7.81 Most Expensive Book Price Most Expensive 129.95

implement this function using javascript. Football Season Stats Page: loadStatsPage method: parameters: none purpose: This method will iterate through the stats table and do the following: 1. Read...

..... Eat your cereal: Boxes of cereal are labeled as containing 14 ounces. Following are the weights, in ounces, of a sample of 12 boxes. It is reasonable to assume that the population is...

Suppose we divide a group of 500 drivers into three groups. In a given year, 325 of those people have only a few door dings or chipped paint, which costs $300 each. Another 115 of the drivers have...