eer diagram, Database Management System

Assignment Help:
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.

Related Discussions:- eer diagram

Defining internal classes and operations, Defining Internal Classes and Ope...

Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c

Guidelines for creation of table, Guidelines for creation of table: ...

Guidelines for creation of table: Table name should begin with an alphabet. In table name, single quotes and blank spaces are not allowed. Reserve words of that DBM

E-R Diagram, The H. I. Topi School of Business operates international busin...

The H. I. Topi School of Business operates international business programs in 10 locations throughout Europe. The school had its first class of graduates in 1965. The school keep

Define the categories of sql statements, Define the categories of SQL State...

Define the categories of SQL Statements? 1) Statements that don't return a result set. This statement class includes INSERT, DELETE, and UPDATE. 2)Statements that return

Explain nested relations, Explain nested relations? Nested relations ...

Explain nested relations? Nested relations The assumption of INF is a natural one in the bank examples we have considered. However, not all applications are best modelled

Correlated and uncorrelated queries, need to get answer for questions 3&4 o...

need to get answer for questions 3&4 on this page in part 1

Er diatgrams, Ask q“A database will be made to store information about pati...

Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

Define ssn of salesman by using database of business trips, Consider the su...

Consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, Fr

Give the levels of data abstraction, Give the levels of data abstraction? ...

Give the levels of data abstraction? There are three levels of Data Abstraction a) Physical level b) logical level c) view level

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd