Example Computer Science Essay Describe the design and the creation of a relational database.

Example Computer Science Essay Describe the design and the creation of a relational database.
The aim of this report is to describe the design and the creation ofa relational database for Whitespace Promotions. The latter includes therecording of:
Staff details and their involvement in campaignsincluding the recording of the activities that staff have been involved in, theamount of time spent on these activities and whether it is chargeable to theparticular campaign

. Client details including contacts for particularcampaigns

. Campaign details

. Advert and placement details

. Invoice information

The first chapter of this report is the introduction. The secondchapter will describe the creation of the EAR model. That is, the E-R model,entity definitions, constraints and assumptions. The latter will be based onthe information requirements analysis. The second chapter will describe therelational model which will be derived from the E-R model. Chapter four willfocus on the implementation and will provide a listing of the SQL tabledefinitions. Finally, chapter five will conclude by providing a criticalevaluation of the final product and a review of the entire exercise.

Chapter 2: TheEAR Data Model

In order to create the EAR model, first of all we have to identifythe entities that will take part in the model. According to the informationrequirements, Whitespace Promotions requires a database to support their keyactivities in an advertising campaign. The purpose of the requested data isessentially the recording of the information necessary to track costs and datesassociated with a campaign. According to the requirements, a list of entitiesis extracted:

. STAFF

. CLIENT

. CAMPAIGN

. ADVERT

. ACTIVITY

. PLACEMENT

. COMPONENT

. FOLDER

. INVOICE

Assumptions

In order to create the EAR diagram, a number of assumptions have tobe made. These assumptions are very important in defining the relationshipsbetween the entities that will comprise the database model. Below, we list therelationships between the entities based on assumptions.

CLIENT-CAMPAIGN: Each client can beinvolved in a number of campaigns. Each campaign is unique for the particularcustomer. For Whitespace productions each client is involved in at least onecampaign. Therefore, the relationship between the client and the campaignentity is one-to-many.

STAFF-CAMPAIGN: Members of staff canparticipate in zero, one or many campaigns. A campaign involves at least onemember of staff. Therefore the relationship between the entities staff andcampaign is many-to-many. In this relationship the participation of the entitystaff is mandatory whereas the participation of the entity campaign isoptional. In order to convert this relationship into 2 1:N relationships, weconnect each entity with a new entity that represents the 1:N-N:1 relationship.The new entity is called TEAM.

STAFF-ACTIVITY: Each member of the staffis involved in one or more activities. Each activity is performed by a specificmember of staff. Therefore the relationship between the entities staff andcampaign is one-to-many.

ACTIVITY-CAMPAIGN: Each activity can bea part of one or many campaigns. A campaign consists of many activities.Therefore the relationship between the entities activities and campaign ismany-to-many. In this relationship the participation of both entities ismandatory. A campaign consists of at least one activity and an activity has tobelong to a certain campaign. In order to convert this relationship into 2 1:Nrelationships, we connect each entity with a new entity that represents the1:N-N:1 relationship. The new entity is called TIMESHEET.

CAMPAIGN-ADVERT: Each campaign consistsof adverts. Each advert is unique for a particular campaign, since its contentis associated with a specific product and thus with a particular campaign. Inaddition to that, each campaign must consist of at least one advert. Therefore,the relationship between the entities campaign and advert is many-to- one witha mandatory participation of the entity advert.

Example Computer Science Essay Describe the design and the creation of a relational database. 6.9 of 10 on the basis of 2679 Review.