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.
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"
You can upgrade a CPU by adding registers and cache memory to it
Indicate whether the statement is true or false
To insert a comment into a C++ program you begin the line with which of the following?
A. || B. \\ C. ** D. //
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