HomeworkLib
Question

Draw the entities and relationships suggested by each word problem.  Include the proper foreign key(s).  Remember to make...

Draw the entities and relationships suggested by each word problem.  Include the proper foreign key(s).  Remember to make a copy for yourself.  

A course may have many sections or not be offered at all (no sections).  Sections always belong to a single course.  Students take at least one and often multiple sections during a semester.  We want to capture a student’s grade and, if that grade is an F, last date attended.  Courses have a CID, course name and department.  Sections have a CRN, a room and a time.  Sections have no students, or many students.  Students have a CWID, name and year (like Sophomore).

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

ANS. In this question, according to provided information, we have 4 entities with attributes (in parenthesis) as:

  1. Course(CID,course name,department) may have one or more sections
  2. Student(CWID,name,year,CID) may take one or multiple sections in a semester
  3. Section(CRN,room,time)
  4. Result(Fail, Pass)

Here, the student may opt for any course in a department so, CID will be foreign key as it is a primary key in the Course table and column of the Student table as Student may opt course of particular CID.

The following diagram shows the Entity-Relationship Model for this Student-Course data model.

course name De ( CID department course COURSE (CRN name selects room CWID CWID STUDENT STUDENT opt for promoted SECTION semes

In the above diagram, CID, CWID, CRN are underlined and are unique keys and primary keys to respective tables.

Here, symbol M represents a one-to-many relationship as one course may have more than one section.

The Result is a weak entity and represented by a double rectangle as it is dependent on Grades.

0 0
Add a comment
Know the answer?
Add Answer to:
Draw the entities and relationships suggested by each word problem.  Include the proper foreign key(s).  Remember to make...
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

  • Help with this assignment for database systems course : Draw the entities and relationships suggested by...

    Help with this assignment for database systems course : Draw the entities and relationships suggested by each word problem.  Include the proper foreign key(s). Remember to make a copy for yourself.   Unary Relationships 3- Employees (Empid, name) can mentor other employees, or not.  Every employee has a single mentor. Mentors only have one person that they mentor at a time (a mentee).  When they get a new mentee we just overwrite the record of the previous mentee. 4- Same as...

  • Create an ER Diagram showing all entities and relationships that describe the scenario below: You are...

    Create an ER Diagram showing all entities and relationships that describe the scenario below: You are commissioned to design a database to keep records of a small college. You talked with various key members of this community and obtained the following information: The college keeps information about students and student performance. Every student is known by her/his first name, initials and last name. They are also identified by a unique StudentID provided by the University. Every student also belongs to...

  • Question: Draw the ERD for the following situation. Show all entities, attributes, relationships, cardinalities, and modalities....

    Question: Draw the ERD for the following situation. Show all entities, attributes, relationships, cardinalities, and modalities. Each student (with attributes StudentID, StudentName, and StudentMajor) must be assigned one advisor (with attributes AdvisorID, AdvisorName, and AdvisorDepartment). Advisors may advise no students or may advise many students. Each student must register for zero or many courses (with attributes CourseID, CourseTitle, and CourseCredits) with the help of one or more advisers. A course may have at least one student registered, and may have...

  • Create an Entity-Relationship Diagram (ERD). In the ERD include the following:

    Create an Entity-Relationship Diagram (ERD).In the ERD include the following: entities primary keys for all entities attributes - use "good" names for attributes, use only single-valued attributes relationships - use Crow's foot or UML notation; name relationships that could be ambiguous cardinality - minimum (optional/mandatory) and maximum (one or many) on both ends of the relationship - use reasonable assumptions if there is insufficient information in the descriptionStudent/Course registration system for a universityStudents have a unique identification number, first name, middle initial, last name, year...

  • Problem Specification: Write a C++ program to calculate student’s GPA for the semester in your class. For each student, the program should accept a student’s name, ID number and the number of courses...

    Problem Specification:Write a C++ program to calculate student’s GPA for the semester in your class. For each student,the program should accept a student’s name, ID number and the number of courses he/she istaking, then for each course the following data is needed the course number a string e.g. BU 101 course credits “an integer” grade received for the course “a character”.The program should display each student’s information and their courses information. It shouldalso display the GPA for the semester. The...

  • Problem 1. Please create the following tables for UMBC bookstore’s textbook management system with appropriate primary...

    Problem 1. Please create the following tables for UMBC bookstore’s textbook management system with appropriate primary keys & foreign keys. Please include drop table statements with cascade constraints before your create table statements so it is easier to grade your create table statements. E.g., suppose you will create table tab1, tab2, including the following before creating them: Drop table tab1 cascade constraints; Drop table tab2 cascade constraints; Assumptions: Each teacher can teach one or more scheduled course sections. Each scheduled...

  • 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...

  • Read, read and read and then think about that you can create perfectly an enhanced ERD...

    Read, read and read and then think about that you can create perfectly an enhanced ERD for the following description. with making sure to include all kind of entities, attributes, and correct cardinality in relationships between entities. Never forget foreign keys. You need to build a database for the Good College. The College database administrator needs to keep track of the students that attend the College, the courses offered by the college, and the college employees. College tracks the first...

  • Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some sample data in Figure 7-16. For Problems and Exercises 1 through 5, draw a Venn or ER diagram and mark it to show the data you expect your query to use to p

    Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some sample data in Figure 7-16. For Problems and Exercises 1 through 5, draw a Venn or ER diagram and mark it to show the data you expect your query to use to produce the results.Figure 7-16: Class scheduling relations (for Problems and Exercises 1-5Figure 7-17 Adult literacy program (for Problems and Exercises 6-14)1. Write SQL retrieval commands for each of the following queries:a....

  • Use the SQL statements provided to create your tables. Write one SQL statement for each of...

    Use the SQL statements provided to create your tables. Write one SQL statement for each of the following problems. You can only use the conditions listed in the tasks. E.g., in task 1, you cannot manually look up pid of Information Systems undergraduate program. Here is the given code: drop table textbook_schedule cascade constraints; drop table textbook_author cascade constraints; drop table schedule cascade constraints; drop table course cascade constraints; drop table textbook cascade constraints; drop table author cascade constraints; drop...

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