Computers and Technology, 12.08.2020 08:01, harleycrider2251

Design a database system to support any number of schools in an area (e. g. School District, Town, or City). The entities should include, Attendance, Classes, Parents, Schools, Students, and Teachers. 1. Write the business rule(s) that govern the relationship between the entities.
2. Given the business rule(s) you wrote in Step 1, create a Crow's Foot ERD. Do not use your free hand to create the ERD.
3. Determine the characteristics of each entity (Attributes).
A teacher can teach a class, and each class is taught by one teacher. So, the teacher can have a One-to-Many (1:M) relationship with the class.
-A student can enroll in many classes, and each class is enrolled by many students.
So, the students have a Many-to-Many (M:N) relationship with classes.
-A student can make attendance, and each attendance is made by each student.
So, the student have a One-to-One (1:1) relationship with the attendance.
-A teacher can check attendances, and attendances are checked by teachers.
So, the teachers have Many-to-Many (M:N) relationship with the attendances.
-A student can attend school, and the school is attended by many students.
So, the student have a One-to-One (1:1) relationship with the school.
-Parents meet with the teacher, and the teacher is met by parents.
So, the teacher has a One-to-Many (1:M) relationship with the students.
-A student has parents. So, the student has a One-to-Many (1:M) relationship with the parents.
-A school can contain classes, and classes are contained in each school. So, the school has a One-to-One (1:1) relationship with the school.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 04:50, edenlbarfield

Which are steps taken to diagnose a computer problem? a) reproducing the problem and using error codes b) reproducing the problem and troubleshooting c) using error codes and troubleshooting d) using error codes and stepping functions

Answers: 1

continue

Computers and Technology, 23.06.2019 00:10, witerose701

Write a function so that the main0 code below can be replaced by the simpler code that calls function mphandminutes tomiles0. original main0 int main) l double milesperhour-70.0; double minutestraveled = 100.0; double hourstraveled; double milestraveled; hourstraveled = minutestraveled / 60.0; milestraveled = hourstraveled * milesperhour; cout < "miles" 2 using namespace std; 4 /* your solution goes here/ 6 int maino 1 test passed 7 double milesperhour 70.0 all tests passed 8 double minutestraveled 100.0; 10 cout < < "miles: " < < mphandminutestomiles(milesper-hour, minutestraveled) < < endl; 12 return 0; 13

Answers: 1

continue

Computers and Technology, 23.06.2019 07:30, cireland

Write a program that inserts the digits of an integer into an array in originalorderfollowed by reverse order. first, promptthe user to enter a positive integer(> 0). determine the number of digits of the integer. create a dynamically allocated integer arrayof a size twice the number of digits. now insert the digits in original order which will occupy half of the array. then, insert the digits in reverse order. finally, output thedigits in thearray. use at least two functions to organize your program.

Answers: 3

continue

Computers and Technology, 24.06.2019 00:30, rustjallison9928

Asecurity policy is a a. set of guidlines b. set of transmission protocols c. written document d. set of rules based on standards and guidelines

Answers: 2

continue

Do you know the correct answer?

Design a database system to support any number of schools in an area (e. g. School District, Town, o...