Question

In the box below, draw a relational model(not ERD) that illustrates the date represented by the...

In the box below, draw a relational model(not ERD) that illustrates the date represented by the ERD described. Specify all primary and foreign keys.

The ERD contains three entities:

The first entity is called STUDENT and contains STUDENTID, StudentLastName, and StudentEmail as attributes.

The StudentID attribute is the primary key for the STUDENT entity.

The second entity is called CLASS and contains classID, className, and classcredit as attributes.

The ClassID attribute is the primary key for the CLASS entity

The third entity is call the DORM and contains dormID, dormName, and dormAddress as attributes

The dormID attribute is the primary key for the DORM entity

The STUDENT entity has many-to-many relationships with the CLASS entity.

The STUDENT entity has many-to-many relationships with the DORM entity( a dorm may have many students but a student us assigned to only one dorm ).

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
In the box below, draw a relational model(not ERD) that illustrates the date represented by the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • QUESTION 1 What is the most common relationship within a relational database? Select the best answer...

    QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...

  • For this assignment, you should create an Entity Relationship Diagram (ERD) in Visio that shows a...

    For this assignment, you should create an Entity Relationship Diagram (ERD) in Visio that shows a many-to-many relationship between DeVry University students and their classes. Since one student can have many classes and each class can have many students, you will need to create an associative entity to store the specific Student_Class data such as grade and attendance. Create the tables as well as the relationships. Don't forget to indicate the Primary Key and Foreign Key in each table. Tables...

  • An IT support organization within a large company wants to develop a relational database to keep...

    An IT support organization within a large company wants to develop a relational database to keep track of its work. We will call users of the organization's service CLIENTs. CLIENTs, as needed, submit requests for help called TICKETs. Each TICKET, in turn, can have multiple PROBLEM ITEMs. There are many SUPPORT SPECIALISTs in the organization. Eventually each PROBLEM_ITEM is assigned to a unique SUPPORT_SPECIALIST. Each SUPPORT SPECIALIST can have multiple PROBLEM ITEMs assigned to him or her. Since PROBLEM ITEMs...

  • Show the ERD for the following piece of the problem statements. Show only entities (or dependent...

    Show the ERD for the following piece of the problem statements. Show only entities (or dependent entities), relationships, multiplicities, primary keys and foreign keys. Create an appropriate primary key if necessary. You don’t need to specify other attributes. If a relationship is M:N, then show two diagrams: both the M:N relationship diagram and its decomposition into two 1:N relationships. (a) A book has one or many keywords and one keyword can be used in zero or many books. (b) A...

  • Please help me answer these: In the relational database model, an entity consists of one and...

    Please help me answer these: In the relational database model, an entity consists of one and only one entity instance (or record). A. True B. False 2. In the relational database model, the foreign key name does NOT have to be the same as the primary key name. A. True B. False 3. Logical relationships between tables (or entities) in the relational database model are created with primary and candidate keys. A. True B. False 4. In the relational database...

  • DRAW THE ERD(CDM) AND GENERATE THE RELATIONAL TABLE (PDM) USING POWER DESIGNER. PLEASE COMPLETE EACH ENTITY...

    DRAW THE ERD(CDM) AND GENERATE THE RELATIONAL TABLE (PDM) USING POWER DESIGNER. PLEASE COMPLETE EACH ENTITY WITH ATTRIBUTES INCLUDING PRIMARY KEY AND FOREIGN KEY CONSTRAINTS PROBLEM 3 - Draw an entity-relationship diagram for the following scenario, stating any assumptions you find it necessary to make, and showing unknown cardinalities and optionalities using question marks on the relationship line. Show also the attributes explicitly mentioned in the scenario and underline any you consider suitable candidates for being primary keys. It is...

  • TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please...

    TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please mark the Primary and Foreign Key ..... Deliverable: Word document with grade sheet followed by Part 1 ERD and the Part 2 relational schema. Part 1: Draw the ERD for the following situation. 8 pts Be sure to: Convert all many-to-many relationships to associative entities. Make sure each regular entity has an appropriate identifier. Make sure attribute names are unique within the ERD Wally...

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

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

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