CIS 2200
Section CMWA
Microsoft Access Project
——————————————————————————————————————————-
– I
nstructions:
You may complete this project either as an individual or as a group of 2-6 people.
Please read all instructions carefully before attempting. Your submission is to consist of a
single Microsoft Access database file, named with the last names of your group members, or
your own full name if you are working as in individual.
Project Specifications
You will be developing a database for a hypothetical event calendar application.
The relevant entities for the application are as follows:
EVENT, LOCATION, PROMOTER, USER, PERFORMER, PERFORMER_TYPE,
EVENT_RATING.
The attributes for the entities are as follows:
EVENT LOCATION PROMOTER USER PERFORMER PERFORMER_
TYPE
EVENT_RATING
Name Name FirstName UserId Name Type Rating
Date Street1 LastName FirstName ContactNumber DateRated
Promoter Street2 CompanyName LastName EmailAddress User
Location City EmailAddress Username Type Event
Description State ContactNumber DateJoined
Country AccountActive
Notes concerning attributes:
● User.AccountActive is an attribute that denotes whether the user’s account has been
activated or not.
● User.DateJoined is an attribute that indicates the date that the user created the account
● User.UserId is a value assigned by the database to the user.
Description of Relationships:
● An event is held in a location.
● A location may or may not be associated with an event, and a location can be
associated with as many events as possible
● An event is organized by a promoter
● A promoter may organize any number of events.
● A performer is of a particular type
● A performer type may or may not be associated with a performer, and a performer type
can be associated with any number of performers
● An event rating is submitted by a user.
● A user may submit zero ratings or ratings for any number of events.
● An event rating is related to a single event.
● An event may have zero ratings or any number of ratings.
You are required to:
1. Create tables for each of the seven entities.
You must ensure that each table has a PRIMARY KEY. You are responsible for
allocating the proper data type to the attributes in each table. Select the data type that
makes the most logical sense. Identify the foreign keys in the tables that have, and
ensure that you choose the settings (Required & Indexed settings) for these attributes
correctly. It is not necessary to create a description for the attributes. (44)
2. Create the indicated relationships between the tables. (20)
3. Create queries for each of the following requirements:
a. A list of all users that shows each user’s first name, last name & the date that
they created their account. (8)
b. A list of active users that shows these users’ User IDs. (11)
c. A list of all events, showing the event name, the date of the event, and the name
of the promoter that is organizing the event. (8)
d. A list of all events & their ratings, showing the name of the event, the ratings for
that event and the id of the user that submitted the rating. (13)
Sample data for your database will be provided.
TOTAL MARKS AVAILABLE – 104