CQ Advertising Agency Case Study - Entity Relationship Diagram - Management Assignment Help

Assignment Task:

Objectives

• To develop a conceptual data model diagram

• To perform logical design and physical design

• To implement a database

Introduction

In this assessment, you are required to perform the following tasks for the case study given below:

• Design and draw an Entity Relationship diagram

• Perform logical and physical design 

• Create a Database in MS-Access

Case Study

CQ Advertising Agency (CQAA) is a successful advertising corporation that displays advertisements belonging to their clients.  CQAA owns many prime location advertisement spots (SPOTS) at various locations in and around Sydney. These SPOTS can be seen in shopping malls, railway stations, building roof-tops and many other places.  Based on the charges applicable, CQAA has classified the SPOTS into three different categories, viz., standard, prime and superior.  Currently, these SPOTS are used for displaying banner like advertisements.  When a new client requests for advertisement options, CQAA suggests the currently available SPOTS to them.  After the selection of the SPOT by the client, CQAA enters into a contract with them to display the client’s advertisement in that selected SPOT for a specified period.

The client is expected to supply and display their banners at the agreed SPOTS themselves and any damages to those banners are not the responsibility of CQAA.

CQAA collects client’s details such as company name, address, contact person, phone, email address, etc.  At the time of making the contract, the CQAA demands an initial payment of 40% of the total charges from the client.  The remaining charges are paid by the client after receiving the final invoice from CQAA. Please note that CQAA charges the client based on the SPOT-category and contract period of advertisement.

This Management Assignment has been solved by our Management Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.