Welcome to Live Chat

Welcome to LiveWebTutors Services, World's leading Academic solutions provider with Millions of Happy Students.

Call Back
logo

24x7 Support Available

To Get the Best Price Chat With Our Experts

chat now

In A Hurry? Get A Callback

shopping cart 0

Subject Solutions Code Description Price Delete

Amount Payable : $0

continue shopping proceed to checkout

World's Leading Assignment Library

Database Modelling & Development of an ER Diagram and Schema, Express Media Advertisers Database

Question Preview:

Project Specification You have been commissioned by Ronda from Express Media to design a database to assist them with managing their magazine advertising orders. Express Media is a publishing company that sells advertising space to clients in magazines that are published every two months. You are only required to provide the design of the database at this time. The Advertisers database will assist sales representative staff to maintain a record of advertisements order details and bookings that flow through to invoicing. The system will also allow managers to produce reports on sales reve...

View Complete Question >>

Question Preview:

Project Specification You have been commissioned by Ronda from Express Media to design a database to assist them with managing their magazine advertising orders. Express Media is a publishing company that sells advertising space to clients in magazines that are published every two months. You are only required to provide the design of the database at this time. The Advertisers database will assist sales representative staff to maintain a record of advertisements order details and bookings that flow through to invoicing. The system will also allow managers to produce reports on sales revenue and sales history. The main purpose of the database is to keep track of orders for advertising space. For advertising orders they would like to store the order date, purchase order number, initials ofthe sales representative handling the order, special instructions, and copy notes. For eachorder Express Media would like to store the order ID, invoice date, magazine issue description,cost price, page size, shape, colour, position, and production notes. Express Media would also like to identify magazine issues in terms of publication name, issueyear, and issue month.

View Less >>

Solution Preview

Relational data structures:

ContactPerson (ContactPersonID, FirstName, LastName, TelephoneNumber, FaxNumber)

DesignAgency (DesignAgencyID, CompanyName, ContactName, PhoneNumber,EmailAddress)

Address (AddressID, StreetAddress, City, State, Postcode)

AdvertisingAgency(AdvertisingAgencyID, BusinessName, ContactName, AddressID,BusinessPhoneNumber, FaxNumber, CommissionPercentage)

question Get solution

$15

Orginal Price : $19.50

Pay Now

Upload Assignments

250 words

side

Get Your Assignment

Don’t delay more, place your order now. Quick assignment help will be offered to you.

Order Now

CUSTOMER REVIEWS

Excellent

logo

Based on 702 reviews See all reviews here

One of the Best Service

I trust LiveWebTutors for my assignments because of their ability to deliver the perfect assignments time and again. Only a few of my assignments required minor revisions. The rest assured it is the best assignment writing service in the market.

Elizabeth
Sydney

Great Service and on time

I felt so exhausted and burdened with the large number of assignments I had to write and desperately needed someone to help me with all the writing and there was LiveWebTutors company on the internet. They finished my assignments before the due date and also offered me a first-timer discount.

Christina
Perth

One of the Best Assignment Provider

I ordered my Mathematics and Marketing assignments from them last month. I received the content on the set date. Most importantly, the assignments were well-written and plagiarism free. I scored a top grade for the assignment written by them. They are a reliable company.

Oli
Brisbane

Very Helpful Customer Service

I was quite unsure about getting my assignment written online but after coming across LiveWebTutors.com, all my worries have vanished. The quality of the assignments written by their writers is just invincible. Their customer support is very polite and helpful. You should try their service at least once

Kabir
Adelaide