eer diagram, Database Management System

Design an EER schema for the following application and
translate the EER schema into relational schemas (and
constraints). It is possible that some requirements cannot
be captured by the EER schema and some constraints
in the EER schema cannot be captured in your relational
schemas. Identify these and describe them in succinct
manner if there are any. List additional reasonable assumptions
if you definitely need them
The facilities consist of a number of sports complexes.
A sports complex has a unique address, and
has an area.
 Sports complexes are divided into two types: the
single sport type and the multi-sport type. No other
types of sports complex exist.
 Each multi-sport complex is partitioned into different
parts; each part has a location indicator (e.g.
center, NE corner, ...) indicating where it is within
the complex; each such part is allocated to exactly
one sport.
 Each complex has exactly one chief organizing person.
 Each complex will hold a number of events (e.g. different
stages of swimming competitions).
 Each event is identified by an event ID, and for each
event there is a planed date, duration, number of
participants, number of officials, and so on.
 We want to keep track of which officials participate
in which event. (But for simplicity we do not keep
track of the sport persons in the event.)
 There are two types of persons that we want to keep
track of: Organizing persons, and Officials. Each
person is identified by a person ID, and has a name
and sex.
 Different equipments are needed for different events.
We are only interested in equipments that are needed
by at least one event.
Posted Date: 11/27/2013 6:40:13 PM | Location : United States

Related Discussions:- eer diagram, Assignment Help, Ask Question on eer diagram, Get Answer, Expert's Help, eer diagram Discussions

Write discussion on eer diagram
Your posts are moderated
Related Questions
Explain cursors in SQL? Cursors in SQL - An object used to store the output of a query for row-through-row processing through the application programs. Cursors are constructs

Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.

What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a

Problem 1. Write an assembly program to find the smallest among two numbers Writing an assembly program to find the smallest among two numbers 2. Explain the intern

wrie a report on whether a BSc n information systems develops the skills required by employers in Database administration

The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.

From SAD to OOAD (Structured Analysis and Design (SAD) to Object Oriented Analysis and Design (OOAD). We will find here how we can map various models in SAD to different model

Briefly describe concurrency execution? Lock - based protocols Locks There are several modes in which a data item may be locked in this section we restrict our attention