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 training session. The Company offers five advanced technology courses, each of which is taught by a teaching team of two or more instructors. Each instructor is assigned to a maximum of two teaching teams or may be assigned to do research. Each trainee undertakes one advanced technology course per training session.

(a) Identify the main entity types for the company.
(b) Identify the main relationship types and specify the multiplicity for each relationship.
State any assumptions you make about the data.
(c) Using your answers for (a) and (b), draw a single ER diagram to represent the data
requirements for the company.


Computer Science & Information Technology

You might also like to view...

Which statement will display the words “Hello World” in a text box?

(A) txtBox.Text = Hello & World (B) txtBox.Text = "Hello" & World (C) txtBox.Text = Hello & "World" (D) txtBox.Text = "Hello" & "World"

Computer Science & Information Technology

You can upgrade a CPU by adding registers and cache memory to it

Indicate whether the statement is true or false

Computer Science & Information Technology

To insert a comment into a C++ program you begin the line with which of the following?

A. || B. \\ C. ** D. //

Computer Science & Information Technology

Jacki is getting a new computer and wants to organize the files and folders on her current one before moving them.  To copy a file from her USB drive to a folder on her hard drive, Jacki needs to click on the file and _____.

A. press the Ctrl+X keys, click the destination folder, and then press the Ctrl+V keys B. press the Ctrl+C keys, click the destination folder, and then press the Ctrl+V keys C. hold down the right mouse button to drag the file to the new location, and then click again D. choose the shortcut icon from the Home tab in the Ribbon to access the Copy command

Computer Science & Information Technology