ZuoTi.Pro
Question

At a college, the college offers courses and students register for courses. A student can register for one or more courses. I

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

To design an Entity Relationship model for this problem, we have the following statements:

1) A student can register for any number of courses

2) Each course can be taken by any number of students

Step 1:

Following are the entities for this college basis the statements provided above:

a) Student and (b) Course

Step 2: Relationship b/w the entities

a) Since one course can be taken by any number of students and one student can enroll for many courses. Hence the cardinality b/w course and student is Many to Many (M:N)

0 0
Add a comment
Know the answer?
Add Answer to:
At a college, the college offers courses and students register for courses. A student can register...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • At a college, the college offers courses. For each course, one or more sections can be...

    At a college, the college offers courses. For each course, one or more sections can be offered. A section is only for one course. A section is identified by CourseID and SectionID combined. A section is taught by only one instructor. An instructor can teach many courses. Assume you are doing this for the current semester and are not worried about past or future semesters. a. Identify the entities for this college. b. Identify the relationships between entities and the...

  • A University database contains information about students (identified by social security number, or SSN) and courses...

    A University database contains information about students (identified by social security number, or SSN) and courses (identified by courseid). Students enroll in courses; each of the following situations concerns the Enrolls-In relationship set. For each situation, draw an ER diagram that describes it (assuming no further constraints hold). 1.Students can enroll in the same course in several semesters, and each offering must be recorded. 2. Students can enroll in the same course in several semesters, and only the most recent...

  • Figure 2 shows the ER diagram that captures important information about Students, Courses and classes in MIT.

    Figure 2 shows the ER diagram that captures important information about Students, Courses and classes in MIT. Figure 2: Data Model for Student course registration a. Convert the ER diagram into a relational database schema. Be certain to indicate primary keys (underline).    Eg. Student (StudentID:text: Student_name:text,.....)    NB: You are required to identify many-to-many relationships in the ER diagram and include Associative / Bridge entities.

  • Name Use complete sentences if possible The following StudentGrade relation (table) stores the Student, Major, and Course information Each student has unique StudentID. Assume that a student has...

    Name Use complete sentences if possible The following StudentGrade relation (table) stores the Student, Major, and Course information Each student has unique StudentID. Assume that a student has only one major. One student can take multiple courses in one SemesterYear. One course can be taken by many students in each SemesterYear. Given values for StudentID, Course Number, and SemesterYear, one can determine all the rest of values for a record. However only Grade is functionally dependent on StudentlD, CourseNumber and...

  • 1) A university database contains information about professors (identified by emp_id) and courses (identified by course_id)....

    1) A university database contains information about professors (identified by emp_id) and courses (identified by course_id). Professors teach courses. Each of the following situations concerns the Teaches relationship set. For each situation, draw an ER diagram that describes it (assuming no further constraints hold). a) Professors can teach the same course in several semesters, and each offering must be recorded. b) Professors can teach the same course in several semesters, and only the most recent such offering needs to be...

  • system analysis and design Class Diagram Scenario An instructor consists of name, address, email, number, and...

    system analysis and design Class Diagram Scenario An instructor consists of name, address, email, number, and salary. There can be either a full-time or part-time instructor. A student consists of name, student number, and email. Students can enroll for at least one seminar in a semester. Each seminar consists of seminar name, seminar number, and fees. Full-time instructors are responsible for taking the seminars. Each seminar can be taken by at least one and at most two instructors. Only two...

  • (identify the BEST choice of primary key in the table) A CSUS student academic record consists...

    (identify the BEST choice of primary key in the table) A CSUS student academic record consists of: student ID, student name, Course registered (e.g. CIS2000), semester registered (e.g. F02. the table may contain records from different semesters), and grade (e.g. I for Incomplete). A student might register for the same course more than once in order to improve grade (e.g. a student got a D for CIS2000 in fall 2019; s/he might register CIS2000 again during spring 2020 in order...

  • Database design Part One (Conceptual Database Design) As a database developer, you have been asked to...

    Database design Part One (Conceptual Database Design) As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU i planning to deliver a number of professional training courses in Al. Each course is delivered by one member of staff at LJMU's Training Centre; each staff is allocated a staff number. The policy of LJMU is to record the start working date of each staff,...

  • Would you please help me with this homework ? 1- Explain what requirements this ER diagram...

    Would you please help me with this homework ? 1- Explain what requirements this ER diagram is implementing 2- Draw an ER diagram (relationships) for the following business rules in a company: • A salesperson manages one or many other salespeople while a salesperson is managed by only one salespeople. • A salesperson can be an agent for many customers but a customer is managed by only one salesperson. • A customer can place many orders. But an order can...

  • Q1. Draw a context level and level – 1 data flow diagram(entities, processes, data store )...

    Q1. Draw a context level and level – 1 data flow diagram(entities, processes, data store ) for the following scenario:          Scenario: You are required to create a DFD (level-0 and level-1) for Online Student Registration System. This system will be used by Students and teachers for advising courses and time table registration purpose. Student will track the course for current semester. Timing for courses is defined by college in which student will select the flexible timings as per his convenience...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT