User Account

All Pages

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

Three level architecture of dbms-logical architecture, Three Level Architec...

Three Level Architecture of DBMS or Logical DBMS Architecture The logical architecture defines how data in the database is perceived by users. It is not deals with how the da

Management and use of database, I need help with some assignments

I need help with some assignments

Describe identifying relationship, Describe identifying relationship? ...

Describe identifying relationship? Identifying relationship: It is relationship among strong entity and a weak entity it is represented through a doubly outlined diamond in C

Explain differance between primary and secondary storage, Explain differanc...

Explain differance between Primary and secondary storage ? Primary and secondary storage Computer storage is classified within primary(main) memory and secondary(per

Client dbms, i need to submit in this topic.

i need to submit in this topic.

State the objectives-data source, You will be analysing a set of financial ...

You will be analysing a set of financial data of your choice. It is not necessary to collect any primary data of your own, and publicly available secondary data will be sufficient

Relational algebraic operators, Problem Explain at least five relationa...

Problem Explain at least five relational algebraic operators with a suitable example. Note: All the above descriptions should be done by taking at least two examples from ou

What are the types of storage devices, What are the types of storage device...

What are the types of storage devices? Primary storage Secondary storage Tertiary storage Volatile storage Nonvolatile storage

Difference between sql and sql*plus, Difference between SQL and SQL*Plus ...

Difference between SQL and SQL*Plus SQL SQL*Plus SQL is a language SQL *Plus is an environment It   is   bas

Shared lock or read lock, Shared lock or Read Lock It is requested ...

Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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