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

Illustrate the state model for the atm class, Illustrate the State model fo...

Illustrate the State model for the ATM class let us take state model for the ATM class given below in Figure showing state model of the ATM class and the pseudo code derived fr

Client server databases, Client Server Databases- The concept behind the C...

Client Server Databases- The concept behind the Client/Server systems is simultaneous, cooperative processing. It is an approach that presents a one systems view from a user's vie

Three level architecture, explain external view

explain external view

What is dml query langauge, What is DML Query Langauge? Data Manipulati...

What is DML Query Langauge? Data Manipulation Language (DML) - A data manipulation language is a language in which enables users to access or manipulate data as organized throu

Benefits and drawbacks of sequential file organisation, Benefits of Sequent...

Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra

Illustrate the class diagram for class room scheduling, Illustrate the clas...

Illustrate the class diagram for class room scheduling system If in any college, the number of classrooms are limited which have to be allocated to various classes and instruct

Problem about data mining for business intelligence, Do the 11.1 11.1 Cre...

Do the 11.1 11.1 Credit Card Use. Consider the following hypothetical bank data on consumers’ use of credit card credit facilities in Table 11.3. Create a small worksheet in Exce

In a relational model how relations are termed, In a relational model how r...

In a relational model how relations are termed? In a relational model, relations are termed as tables. (The term ‘relation’ is the technical name of the ‘table’ in RDBMS)

Describe about use case and external case in dfd, Describe about Use Case a...

Describe about Use Case and external case in DFD The processes are transformed those into the Use Case and external case in DFD has same characteristics which of an actor in O

Create a query to produce single output-er model, This assignment concerns ...

This assignment concerns the Research database. The database ER model is shown above, where attributes are omitted for clarity. The relational model for the database is: Departm

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