sql, Database Management System

Assignment Help:
Events4Fun is an event management company in Europe with branches in South America as well.
The company is well-known for its efficiency, good-quality services, and affordable charges. It
manages various types of events throughout the year. These events include fashion shows,
celebrity shows, charity shows and musical exhibitions. The details related to the type of events
are stored in the EventType file. The details stored in this file consist of event type ID, description
of the event, and charge per person for a particular event.
Events4Fun organizes events for its registered and new customers. The company stores details of
its customers, such as customer ID, name, address, city, state, and phone numbers, in the
Customers file. When a customer approaches the company for organizing an event, the customer
has to specify the type of event and make payment for the selected type. The details of the
selected event are stored in the Events file. The details stored in this file consist of:
Event ID
Event name
Event type ID
Location of the event
Start date
End date
Staff required for the event
ID of the employee managing the event
Customer ID
Number of people attending the event
In addition, the payment details, which include payment ID, event ID, payment amount, payment
date, credit card number, card holders name, credit card expiry date, payment method ID, and
cheque number, are stored in the Payments file.
All the Events4Fun events are managed by its efficient employees. The company stores employee
details, such as employee ID, first name, last name, address, designation, and phone numbers, in
the Employee file.
Due to the high quality of its service, the company has seen a tremendous increase in the number
of customers. Consequently, maintaining information about events, customers, and employees
manually has become difficult. Therefore, the management has decided to use a computerized
event management system. For this, the management approaches MagicTech Inc. to develop the
application.
At MagicTech Inc., Harry and his team have been assigned the task of creating the required
application. Being the database developer in the team, you have been assigned the task of
analyzing the application and creating the required database and tables.
You need to analyze the requirements of the preceding application and perform the following
tasks:
1. Identify the various entities and their attributes involved in the application. [5 Marks]
2. Identify the attributes of the entities that are unique to each entity. [3 Marks]
3. Identify the relationships that may exist among the entities of the application. [2 Marks]

Related Discussions:- sql

What is an operand, What is an Operand? The data on which the operation...

What is an Operand? The data on which the operation is to be performed is known as an Operand

Define average latency time, Define average latency time. The average l...

Define average latency time. The average latency time of the disk is one-half the time for a full rotation of the disk.

Introduction to database technology, 1. Create the tables for the play-sche...

1. Create the tables for the play-scheme database as specified in the TMA. 2. Enter the data as given in the spreadsheet. 3. Create queries to retrieve specified information

What is the aim of logical schema, What is the aim of logical schema ? ...

What is the aim of logical schema ? The main motive of the logical schema is to ensure the portability of procedures and models on various physical schemas at runtime.

Horizontal Fragmentation, I want to fragment existing table using java code...

I want to fragment existing table using java code... help me..!!

Project, I need help in doing my dbms project

I need help in doing my dbms project

Explain query tree represent relational algebra expression, How does a quer...

How does a query tree represent a relational algebra expression?      Ans: This includes transforming an initial expression (tree) into an equivalent expression (tree) that is

Key, Q.   Explain the terms key constraints participation constraints and m...

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

Write Your Message!

Captcha
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!

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