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

Ask an Expert

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

Write your message here..

Related Questions

State the technique for converting a state diagram to code, Q. State the Te... Q. State the Technique for converting a state diagram to code. i) Identify the major control path. Starting with first state, find the path from diagram that corresponds

Describe the functions and features of foreign key, Describe the functions ... 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

List the sql domain types, List the SQL domain Types? SQL supports the ... List the SQL domain Types? SQL supports the following domain types. 1) Char(n) 2) varchar(n) 3) int 4) numeric(p,d) 5) float(n) 6) date.

Explain the functional mode with help of an example, Explain the Functional... Explain the Functional Mode with help of an example. Functional Model  The functional model shows a computation and functional derivation of data values in it without ind

Normalise data to third normal form, A software contract and consultancy fi... A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe

I need label printing program, Project Description: Hi I'm seeking someo... Project Description: Hi I'm seeking someone to make my dBase application work. I know it's not a 'modern' language but it's what I know. I have written an order program and I ne

Relational algebra, what is union compatable? what is union compatable?

What is known as fudge factor, What is known as fudge factor? The numbe... What is known as fudge factor? The number of partitions is enhanced by a small value called the fudge factor, which is usually 20 percent of the number of hash partitions compu

Explain dbms- ddl-domain-alias, Briefly explain each of the following datab... Briefly explain each of the following database terms. Use no more than 2-3 lines for each term. 1. DBMS 2. Update Anomaly 3. Alias (referring to tables in SQL queries)

Table handling, Table Handling  In RDBMS more than one table can be tac... Table Handling  In RDBMS more than one table can be tackled at a time by using join operation. Join operation is a relational operation that causes 2 tables with a common domai