User Account

All Pages

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

2phase locking, we need example of 2phase locking

we need example of 2phase locking

Domains, Every simple attribute of an entity type have a possible set of va...

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

Homework, can you resolve this for me please? Database Management Systems ...

can you resolve this for me please? Database Management Systems Homework 1 The following relations are given (primary keys are underlined): PLAY-ACTOR(AId, Name, Nationality, Birt

Relation schema for student, Example RELATION SCHEMA for STUDENT: STU...

Example RELATION SCHEMA for STUDENT: STUDENT (Roll No: string, name: string, login: string, age: integer) RELATION INSTANCE

In which relational modes cardinality is termed, In which relational modes,...

In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.

Explain the difference between drop and delete, Explain the Difference betw...

Explain the Difference between DROP and DELETE DELETE deletes one or more than one tuples of a particular relation from the database. DROP is employed to remove a table from th

Organic compounds, #question.explain diversity and magnitude of organic com...

#question.explain diversity and magnitude of organic compounds and general properties?

What is a virtual table that draws its data from the result, What is a virt...

What is a virtual table that draws its data from the result of an SQL SELECT statement? View is a virtual table that draws its data from the result of an SQL SELECT statement.

Describe the association - design, Describe the Association: Design  ...

Describe the Association: Design  Before we describe association design let us define association "Association is set of links between two objects in the object model". It is

Define timestamp ordering, Define Timestamp ordering Ans In timestamp-b...

Define Timestamp ordering Ans In timestamp-based method, a serial order is made among the concurrent transaction by assigning to every transaction a unique nondecreasing number

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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