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 is the use of rename operation? Rename operation is used to rename both relations and an attributes. It uses the as clause, taking the form: Old-name as new-name.

What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a

Task Partitioning, Sequencing and Project Planning The tasks required for the service might be broadly partitioned into: 0.      Set up database tables and account file

Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in t

Lack of Redundancy We have talked about the problems of repetition of information in a database. Such repetition should be stay away as much as possible. Let us state once again t

What is called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known

Examples:- Hierarchical Model: It tells data as and relationships by hierarchy of data values. Figure illustrates an example of hierarchical model. Now a day's these models are

Discuss the problem of Spurious tuples and how we may prevent it.    Ans:  A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad

What is Oracle Process? Explain any four processes started by Oracle. Oracle Process is as follows: SMON: The System Monitor carries out a crash recovery while a crashed in

State the Component Diagram A component diagram represents a set of component and relationships among them. In a dynamic model, component diagram is used to model physical com