HomeworkFour

HomeworkFour - do research. Each trainee may take up to two...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Your Name _____________________________ Homework Four 3 points total 1. (1.5 points) The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for its training program. The HEG administrator gives you the following description 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 10 trainees in it, it will be canceled. It is, therefore, possible for a course not to generate any classes during a session. Each class is taught by one instructor. Each instructor may teach up to two classes or may be assigned to
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: do research. Each trainee may take up to two classes per session. Given this information, do the following: a. Draw the E-R diagram for HEG. b. Include connectivity, cardinality, and existence dependence (if any) on your model. (hint. . there is extra information in the description) Your Name _____________________________ 2. Us the following ER diagram to answer the questions below. (1.5 points) a. Write the proper cardinalities for each entry: a. (a,b) b. (c,d) c. (e,f) d. (g,h) e. (i,j) f. (k,l) g. (m,n) h. (o,p) b. Write the proper connectivities for each entry: a. W b. X c. Y d. Z ABC AB_DE ABC xxxxx yyyyy DEF JKL 1 1 M W X Y Z M (e,f) (g,h) (a,b) (c,d) (m,n) (o,p) (i, j) (k, l) Your Name _____________________________...
View Full Document

Page1 / 3

HomeworkFour - do research. Each trainee may take up to two...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online