ZuoTi.Pro
Question

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 required to keep the following information on students, courses and subcourses. Each student has a name, identification number, home address, term address, and a number of qualifications for which the subject (e.g. maths), grade (e.g. C) and level (e.g. `A' level) are recorded. Each student is registered for one course where each course has a name (e.g. Information Systems) and an identification number. Record is kept of the number of students registered for each course.
Each course is divided into subcourses where a subcourse may be part of more than one course. Information on subcourses includes the name, identification number and the number of students taking the course.

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

Homework Answers

Answer #1

Solution:

0 0
Add a comment
Know the answer?
Add Answer to:
DRAW THE ERD(CDM) AND GENERATE THE RELATIONAL TABLE (PDM) USING POWER DESIGNER. PLEASE COMPLETE EACH ENTITY...
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

  • The following are the main entity types of the academic institution database. For each entity type,...

    The following are the main entity types of the academic institution database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: (a) Build an Enhanced E-R diagram; (b) Transform the Enhanced E-R diagram to a relational database. Identify the primary key(s) and the foreign key(s) for each relation. Draw the relational integrality constraints; (c) For each of the relations created, indicate its normal form. If the relation is not in the 3NF,...

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

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

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

  • Homework Help!! 1. Draw an ERD for the following situation. Be sure to show: entity information,...

    Homework Help!! 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by...

  • 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s),...

    1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or...

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

  • You will need draw a normalized entity relationship diagram (ERD) for the case described below. You...

    You will need draw a normalized entity relationship diagram (ERD) for the case described below. You only need to show your final ERD in 3NF. Case The North Carolina Division of Employment Security wants to build a system that tracks job seeking activity for unemployed individuals. When each individual applies for unemployment (referred to as an applicant) he/she is assigned a job coach who is responsible for monitoring the applicant’s job seeking activity. The development team has tentatively identified the...

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

  • You have been approached by a University for the design and implementation of a relational databa...

    You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database design process provided the following data requirements for the University Database system. Using the following requirements answer this...

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