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

Functional dependency, Functional Dependency Consider a relation R that...

Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every

Differance between procedural and non procedural dml, Differance between pr...

Differance between procedural and non procedural DML? Procedural and non procedural DML Procedural DML exactly what data is require and how to obtain those data. Non procedural

Database problem in wordpress, Project Description: I am having a random...

Project Description: I am having a random problem with my Wordpress site. If I click on "Publish" and "Add new", it takes me to a 404 page not found of /wp-admin/post.php (th

Process to find the non-concurrent objects, Process to find the non-concurr...

Process to find the non-concurrent objects Once we find out non-concurrent (mutually exclusive) objects, we can fold all objects together in one thread of process or control. O

Distributed transaction atomic-consistent-isolated, A distributed transacti...

A distributed transaction consists of subtransactions that execute at different sites and access local DBMSs at those sites. For example, a distributed transaction that transfers m

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

What is recursive closure and operation relational algebra, What is recursi...

What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec

Relationship cardinality, Cardinality shows the number of instances of an e...

Cardinality shows the number of instances of an entity associated with another entity participating in a relationship. Depend on the cardinality binary relationship can be further

Central database schema, Show a centralised schema to support the operation...

Show a centralised schema to support the operation of the system you have chosen, including in particular: the product catalogue; the outlets and respective stocks; customer record

Participation constraints, explain participation constraints with examples

explain participation constraints with examples

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