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
Demonstrate the UML model Using UML, it is possible to generate code in any of the programming language from UML model (called forward engineering) and rebuild a model from an

Create role named role_table that allows a user to create tables. Using role_table allow users kripa and reena to create tables. CREATE ROLE role_table; GRANT CREATE ANY TABLE

MOSS VALE is a town with 15000 inhabitants. The fire department wishes to develop a system that automates the despatch of fire engines to attend fires. The ERD below describes the

What is the use of keyword ISA? The use of keyword ISA is to show that a class is a specialization of another class.

Enumerate or state the steps in creating a relevant database of a shop.

Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod

Describe the functions and features of foreign key? Foreign Key : The primary key of one file or table that is implanted in another file or table to implement the relationships

What is OLAP? OnLine Analytical Processing (OLAP) is a Business Intelligence (BI) reporting system. OLAP gives the user with the capability to sum, count, average and do other

Describe the nested-loop join and block-nested loop join.   Ans:   The block nested- loop join algorithm is as described below:     for every block B r of relation R do beg

What is a view? How it is related to data independence? A view might be thought of as a virtual table, that is, a table that does not really exist in its own right but is inste