HomeworkLib
Question

Write a scenario and the corresponding ERD that would display at least 5 entity types, at...

Write a scenario and the corresponding ERD that would display at least 5 entity types, at least one relationship type of each multiplicity (one-to-one, one-to-many, many-to-many), at least one complex relationship type (degree 3 or more), and at least one recursive relationship type. The model should also feature at least one derived attribute and one composite attribute.  

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

Homework Answers

Answer #1

Scenario thatcontains all the given conditions: Schoo The school has teachers, students, departments, progress card and clubsThe ERD diagram for the given scenario can be derived as given belov: Note: Used minimal attributes for clarity and to satisfRank Name DOB Grade Remarks StudentID Name HProgressReprt Student Possess Subjects HouseNum Department (address) Enrolled str

0 0
Add a comment
Know the answer?
Add Answer to:
Write a scenario and the corresponding ERD that would display at least 5 entity types, at...
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

  • I have created an ERD for the provided scenario, however I am having some trouble changing...

    I have created an ERD for the provided scenario, however I am having some trouble changing it into a Relational Model table, any help would be appreciated. The task is below, along with the ERD I came up with. Derive a Relational Model from the conceptual schema you provided in Task 1 (it should match exactly). For the purpose of this assignment, only derive the part of the database that stores the information about players, quests, beacons and treasures (considering...

  • Identify all entity types, attributes, relationship types and their degrees in the following case Hence draw...

    Identify all entity types, attributes, relationship types and their degrees in the following case Hence draw an entity-relationship diagram An organization makes many models of cars where a model is characterized by a name and a suffix (such as GL or XL which indicates the degree of luxury) and an engine size. Each model is made up from many parts and each part may be used in the manufacture of more than one model. Each part has a description and...

  • This is symbolized by a circle over a single line in an entity relationship diagram. It...

    This is symbolized by a circle over a single line in an entity relationship diagram. It signifies that the supertype does NOT have to be one of the specified subtypes. Partial completeness Total completeness System completeness Associative completeness A supertype entity can contain as many as ____ subtype entities. 10 1 100 no defined limit When you set up an Entity Relationship Diagram, and have a many-to-many relationship, this entity is created to avoid problems inherent to a many-to-many relationship....

  • a. Suppose that a model of a music library does not model ‘artist’ as an entity...

    a. Suppose that a model of a music library does not model ‘artist’ as an entity set, but instead models it as an attribute of a track. This could lead to what the authors of our text call ‘incompleteness’. Why would the they call this model incomplete? Is it because a) not all artist information could be contained as an attribute of a track, b) it would not be possible to model an artist before that artist released any tracks,...

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

  • Part I: Create an Entity-Relationship Diagram (ERD) based on the REA Model During an internship with...

    Part I: Create an Entity-Relationship Diagram (ERD) based on the REA Model During an internship with James Merchant, CPA, you were asked to create a database for the firm to help with billing and cash receipts. Merchant employs one staff accountant, a bookkeeper and one intern. Currently, Merchant uses a paper-based system to keep up with customer billing. He feels that he would have better control over the billing and cash receipts if used a computerized system. Merchant specializes in...

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

  • In Module Four, submit a systems analysis for your project, including a comprehensive entity-relationship diagram (ERD)....

    In Module Four, submit a systems analysis for your project, including a comprehensive entity-relationship diagram (ERD). Although you may use any tool to complete the ERD, it is strongly recommended that you use Microsoft Visio and then save the diagram into an image format (GIF or JPG) and then copy and paste the image into your systems analysis. All sections of this milestone should be compiled into a single Word document. Furthermore, all of Milestone One should be included in...

  • A nonprofit organization depends on a number of different types of persons for its successful operation....

    A nonprofit organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address, City/State/Zip, and Telephone. Three types of persons are of greatest interest: employees, volunteers, and donors. Employees have only a Date Hired attribute, and volunteers have only a Skill attribute. Donors have only a relationship (named Donates) with an Item entity type. A donor must have donated one or...

  • Entity relationship diagram (ERD) question: An online food delivery company hires you to design a small...

    Entity relationship diagram (ERD) question: An online food delivery company hires you to design a small database to store information about the online orders. You’re given the following requirements: ⚫ A customer is uniquely identified by his/her email. For each customer, we also record his/her name, phone number and address. The address is composed of suburb and street. ⚫ A rider is uniquely identified by his/her ID. We will keep record of the rider’s age, gender, phone number and available...

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