Construct an e-r diagram for the database

Assignment Help Database Management System

Reference no: EM13750593

Consider a database used to record the marks that students get on different examinations of different course offerings.

(a) Construct an E-R diagram for the database that models exams as entities, and uses a ternary relationship.

(b) Construct an alternative E-R diagram that uses only a binary relationship between students and course_offerings. Make sure that only one relationship exists between a particular student and course_offering pair, yet you can represent the marks that a student gets in different exams of a course offering.

(c) Design an E-R diagram for keeping track of the exploits of your favorite sports team. You should store the matches played, the scores in each match, the players in each match, and individual player statistics for each match. Summary statistics should be modeled as derived attributes.

(d) Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents.

(e) A weak entity set can always be made into a strong entity set by adding to its attributes the primary key attributes of its identifying entity set. Outline what sort of redundancy will result if we do so.

Reference no: EM13750593

Questions Cloud

Explain sr-rm-004 project : Assignment: Explain SR-rm-004 Project Approach, Resource: Riordan Manufacturing Microsoft Project file

Outline individual and group decision-making processe : Analyze the formation and dynamics of group behavior and work teams, including the application of power in groups. Outline various individual and group decision-making processes and key factors affecting these processes, including ethical considera..

Requires the construction of a document : Portfolio Project 3:The third portfolio entry requires the construction of a document that reflects the information you have learned in Unit V.The assignment will also test your ability to think critically about the concepts within the unit. This por..

Response to the editorial : Write a one paragraph summary followed by a one paragraph (at least) response to the editorial. here is the link to the source. http://www.nytimes.com/2015/06/04/opinion/zeynep-tufekci-mark-zuckerberg-let-me-pay-for-facebook.html?ref=opinion&_r=0

Construct an e-r diagram for the database : Consider a database used to record the marks that students get on different examinations of different course offerings. Construct an E-R diagram for the database that models exams as entities, and uses a ternary relationship

How hit system and vendor selection processes should be used : Write a 400- to 500-words paper in which you do the following- Demonstrate how HIT system and vendor selection processes should be used.

The opportunity to apply thesociological imagination : Thepurpose of this assignment is to give you the opportunity to apply thesociological imagination to your everyday life: To make connections betweenyour everyday life and the broad sociocultural structures within which youlive. In this assignment

Explain the purpose of simple linear regression : Explain the purpose of simple linear regression and scatter diagrams. Please provide a simple linear regression model and define each variable used

An automated ticket-issuing system : You have been asked to develop UML diagrams to graphically depict and describe the architecture of two (2) unrelated software systems. An automated ticket-issuing system used by passengers at a railway station

User Account

All Pages