subject

MIIT needs a database. MIIT is an Information Technology (IT) institute with hundreds of students. It is necessary to keep track of all the different classes that are being offered, who is assigned to teach each class, teaching assistant assignments, and which students take each class. Also, it is important to track the progress of each student as they advance

(i)Students are given a student number when they join the school. This is stored along with their name, date of birth, address, contact number, and the date they joined the school.

(ii) All teaching assistants are also students, but clearly, not all students are teaching assistants. In addition to the normal student information, for each teaching assistant, the date that they start working as a teaching assistant must be recorded, along with their status (compensated or volunteer)

(iii) Each teaching assistant is assigned to one and only one instructor. An instructor can have maximum of two teaching assistants. Not all instructors have teaching assistants

(iv) MITT offers several sections (classes) of each course. An instructor may be assigned to teach any number of classes, but each class has one and only one assigned instructor. Some instructors may not be assigned to any class. Each class is offered during a given semester. Semester defines the year and the term that the class will be offered (e. g., Fall 2018)

(v) There are three levels of courses; beginner-level, intermediate-level, and advanced-level. Student carn take multiple classes at the same level in a given semester. Once a student has completed all the required courses for a given level she/he receives a certificate. Each course belongs to one and only one level. Each level has at least three courses. A list of required courses for each level are stored MITT needs to keep track of all certificates issued to each student and issue dates.

1. Identify all the entities in this company.

2. For each entity, list its attributes.

3. Describe the possible relationships between the various entities.

4. Now create a Crow's Foot notation E-R diagram for this case. For each entity, include the attributes, the primary key, and foreign keys (if any). Name each relationship and diagram both the minimum and maximum cardinalities. If you cannot infer the cardinalities from the case description, make your own assumption. You can use Visio, Word or any other drawing software to draw your ERD.

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 21.06.2019 22:00, kadariusmerchan
Determine which of the four levels of measurement (nominal, ordinal, interval, ratio) is most appropriate for the data below. internet speed levels of "fast comma " "medium comma " and "slow" choose the correct answer below. a. the ordinal level of measurement is most appropriate because the data can be ordered comma but differences left parenthesis obtained by subtraction right parenthesis cannot be found or are meaningless. nothing nothing nothing nothing nothing b. the interval level of measurement is most appropriate because the data can be ordered comma differences left parenthesis obtained by subtraction right parenthesis can be found and are meaningful comma and there is no natural starting point. c. the nominal level of measurement is most appropriate because the data cannot be ordered. nothing d. the ratio level of measurement is most appropriate because the data can be ordered comma differences left parenthesis obtained by subtraction right parenthesis can be found and are meaningful comma and there is a natural starting point.
Answers: 2
image
Computers and Technology, 22.06.2019 17:00, smartoa
Annie is creating a corporate report for a company’s annual meeting. in the report, she wants to add the signature of various department heads. which device can annie use to capture signatures to include in the report? a. printer b. monitor c. e-reader d. digitizing tablet
Answers: 1
image
Computers and Technology, 23.06.2019 15:00, ryleerose255
Idon’t understand the double8 coding problem. it is java
Answers: 1
image
Computers and Technology, 23.06.2019 22:30, delawdermia27
The output voltage of a power supply is assumed to be normally distributed. sixteen observations are taken at random on voltage are as follows: 10.35, 9.30, 10.00, 9.96, 11.65, 12.00, 11.25, 9.58, 11.54, 9.95, 10.28, 8.37, 10.44, 9.25, 9.38, and 10.85
Answers: 1
You know the right answer?
MIIT needs a database. MIIT is an Information Technology (IT) institute with hundreds of students. I...

Questions in other subjects:

Konu
English, 28.01.2020 12:31