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

The conceptual level or global level in dbms, The Conceptual Level or Globa...

The Conceptual Level or Global level The conceptual level presents a logical view of the complete database as a unified whole. It permits the user to bring all the data in th

Explain the term- periodic recomputation, Explain the term- Periodic recomp...

Explain the term- Periodic recomputation Periodic recomputation:  Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes p

Sequences-data control, Sequences Sequences: Automatically produ...

Sequences Sequences: Automatically produce unique numbers Are sharable Are typically used to make a primary key value Replace application code Speed up t

Need for client server computing, Need for Client Server Computing- Client/...

Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

Participation constraints, explain participation constraints with examples

explain participation constraints with examples

Distributed database, distributed quey processing

distributed quey processing

Explain relational model and their use in dbms, Explain Relational model an...

Explain Relational model and their use in DBMS? Relational Model - The relational model was first introduced through E.F. Codd of the IBM Research in the year of 1970. The mode

Insulation between conceptual and physical structures, Insulation between c...

Insulation between conceptual and physical structures It can be defined as: 1. The Database Administrator should be capable to vary the storage structures without affectin

Explain dml with some examples, Explain DML with some examples? DML - D...

Explain DML with some examples? DML - Data Manipulation Language: statements used for managing data within schema objects. Some examples: • SELECT - retrieve data from the a da

What is a primary key, What is a primary key? Primary key is chosen by ...

What is a primary key? Primary key is chosen by the database designer as the principal means of identifying an entity in the entity set.

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