Question

Draw an EERD for the following situation. Students are required to turn in assignments. Attributes of...

Draw an EERD for the following situation. Students are required to turn in assignments. Attributes of STUDENT include StudentID (identifier), Name, and Major. Attributes of ASSIGNMENT include AssignmentNo (identifier) and DueDate. The grade obtained by each student for each assignment is recorded.

Assignments may be either modeling or computer assignments. Computer assignments have an additional attribute, PlatformUsed. Modeling assignments are based on cases. A case may be used in one or more modeling assignments, and a given modeling assignment is associated with exactly a case. Attributes of CASE include CaseNo (identifier) and Author.

[Note: M:N relationships need to be converted to associative entities.]

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Enhanced Entity Relationship diagram:

The Enhanced entity relationship diagrams are a representation for the interactions between the entities.

These avdanced database diagrams are similar to the Er diagrams with advanced properties in it.

The entities have attributes which are of various types.

These attributes are mentioned in the diagram below.

EER diagram:

The EER diagram is represented as shown below.

0 0
Know the answer?
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
Similar Questions
Homework 3 Before attempting this project, be sure you have completed all of the reading assignments,...
Homework 3 Before attempting this project, be sure you have completed all of the reading assignments, hands-on labs, discussions, and assignments to date. Create a Java class named HeadPhone to represent a headphone set. The class contains:  Three constants named LOW, MEDIUM and HIGH with values of 1, 2 and 3 to denote the headphone volume.  A private int data field named volume that specifies the volume of the headphone. The default volume is MEDIUM.  A private...
You have to create a Library Borrowing System based on the following requirements: When new books...
You have to create a Library Borrowing System based on the following requirements: When new books arrive, these books must be cataloged into the system by a librarian (i.e., entered in the system). Information on a book should include book ID, title, author ID, ISBN, and edition. The system should capture author names so that users can search for an author. The library may carry multiple books by the same author, and an author can have multiple books in the...
Use ONLY the classes in this list to draw a Class diagram. The diagram must show...
Use ONLY the classes in this list to draw a Class diagram. The diagram must show all the classes, their attributes, and the relationships between the classes. All the associations must have proper multiplicity constraints indicated. Note that class methods and attribute types are not required.                                                                                                               Domain classes and their attributes Order [date/time, total price, status] Account [full name, address, phone, email] SellerAccount (no attributes) BuyerAccount [credit card] Book [title, ISBN, author, publisher, asking price] BookOnOrder [quantity] Dispute [reason]...
Develop an application to support course administration. Read the following detailed description of this application, and...
Develop an application to support course administration. Read the following detailed description of this application, and complete the tasks listed below. *. A course has a unique course number and title, and is assigned to one or more areas of the Computer Science program. Each course has an instructor, at least one teaching or research assistant, an online conference whiteboard, a time (interval), and a capacity (maximum number of participants). A course need not be offered each term, but the...
Draw an E-R diagram pls Required Data The data items required for the train reservation database...
Draw an E-R diagram pls Required Data The data items required for the train reservation database can be classified into six categories: trains, stations, train schedules, reservations, customers and employees. The above classification does not imply any particular table arrangement. You are responsible for arranging the data items into tables, determining the relationships among tables and identifying the key attributes. Finally, you should specify and enforce integrity constraints on the data, including referential integrity constraints. You will first create an...
Functions displayGrades and addGrades must be rewritten so that the only parameters they take in are...
Functions displayGrades and addGrades must be rewritten so that the only parameters they take in are pointers or constant pointers. Directions: Using the following parallel array and array of vectors: // may be declared outside the main function const int NUM_STUDENTS = 3; // may only be declared within the main function string students[NUM_STUDENTS] = {"Tom","Jane","Jo"}; vector <int> grades[NUM_STUDENTS] {{78,98,88,99,77},{62,99,94,85,93}, {73,82,88,85,78}}; Be sure to compile using g++ -std=c++11 helpWithGradesPtr.cpp Write a C++ program to run a menu-driven program with the...
Directions: Develop an E-R (or EER depending upon need) Diagram. List all assumptions. Show the version...
Directions: Develop an E-R (or EER depending upon need) Diagram. List all assumptions. Show the version 1 (entities and data only) and version 3 (entities, attributes and relationships with cardinalities and participation constraints). 20 points of the grade will be based on evaluating your assumptions - you must give a detailed list of your assumptions identifying anchor concepts, data associated with the anchor and data that has more than one anchor participating in it. Remember, we are not talking out...
PLEASE READ THE ARTICLES ATTACHED AND ANSWER THE FOLLOWING QUESTION. THE ARTICLES ARE BOTH LISTED PLEASE...
PLEASE READ THE ARTICLES ATTACHED AND ANSWER THE FOLLOWING QUESTION. THE ARTICLES ARE BOTH LISTED PLEASE PROVIDE DETAILED EXPLANATIONS. PLEASE WRITE ONE REFLECTION COMBINING BOTH ARTICLES. The purpose of the Article Reflection is to deepen your engagement with the topic of Epidemiology. It will give you the opportunity to reflect on the current real-life epidemiological issues at hand and help to bring meaning to them. ARTICLE 1: A group of students knew they had covid-19. They hosted a party over...
Develop a 2018 individual tax return (with all required forms and supporting schedules) for Rob and...
Develop a 2018 individual tax return (with all required forms and supporting schedules) for Rob and Laura Petrie that is both professional in appearance and technically correct. The use of tax software or a professional tax preparer to complete this project is prohibited. You can access fill-in forms (in pdf format) on the IRS website (www.irs.gov) by clicking on “More” on the left side of the homepage in the “Forms and Pubs” section. Next, click on the “Current Forms and...
Case Study: Freeman-Brown Private School (FBPS), based in Illinois, was founded in 1944 by the Brown...
Case Study: Freeman-Brown Private School (FBPS), based in Illinois, was founded in 1944 by the Brown and Freeman families. Over the years, the school acquired a reputation as a leading academic institution with an advanced curriculum. Parents described the school as having a highly performing academic environment that provided a rigorous curriculum while fostering a safe, family-oriented atmosphere in a place where community was valued. Not surprisingly, the student population grew and the school opened multiple campuses in the metropolitan...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT