Draw entity-relationship diagram of database, Database Management System

Read the description below and draw an Entity-Relationship diagram for it. You must use the symbols described in the course materials.

This database will help the Parents Assocciation of the local school to manage their upcoming Summertime Fete. The main aim of the database is to manage aspects of the operation of the stalls.

1 PA members are represented in the database. Their name is used to identify them and their email address is also recorded.

2 All stall are given a unique title ("Bring and Buy", "Cakes", etc). The stall also has a location and the number of people required to operate it.

3 Stalls are sponsored by companies and local businesses. Each sponsor has a company name, contact number, contact person and their advertising slogan is included in the database (to be announced over the Public Address system on the day of the fete)

4 Companies usually sponsor many different stalls. The amount donated to each stall is recorded. Most stalls need sponsorsip from more than one company. Every company in the database must sponsor at least one stall.

5 Work times are 1 hour in duration. Each slot is known by its commencement time (eg "the 11AM slot"). No other information is recorded about time slots.

6 Members work on stalls in selected time slots. There are not restrictions on members working on stalls, etc except for one condition; for a given time slot, a member can only work on one stall.

7 At the fete, there are range of administrative jobs that need attending to. They are identified by the task. There is also a record of the equipment required for the task.

8 Some members will be assigned a job but no more than one job. Some jobs are complex and will need many people to complete them.

Posted Date: 3/19/2013 5:29:54 AM | Location : United States







Related Discussions:- Draw entity-relationship diagram of database, Assignment Help, Ask Question on Draw entity-relationship diagram of database, Get Answer, Expert's Help, Draw entity-relationship diagram of database Discussions

Write discussion on Draw entity-relationship diagram of database
Your posts are moderated
Related Questions
what characterizes the levels in RAID technology

Explain query execution plan? - Optimizer available in SQL Server optimizes code to be effectively executed. - A query execution plan demonstrates how this optimizer would r

SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail:

FDs in Relationships:  Enrols Relationship: None as it is many to many Teaches Relationship : Course code → Instructor Instructor → Course code The next question is:

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

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

What is the most significant feature that does not directly map into programming language structures? Why? Association, since there are complex types of association, like as qu

Forward Recovery (Redo): In this system the committed changes made by a transaction are reapplied to a previous copy of the database.                          In simpler

Every simple attribute of an entity type have a possible set of values that can be attached to it. This is known as the domain of an attribute. An attribute cannot have a value out

What is the purpose of tables, private synonyms and public synonyms? If there are multiple objects of similar name on an Oracle database, that order are they accessed in? The r