Solution-List all new customers by region

List all new customers by region

Assignment Help Management Information Sys

Reference no: EM132279274

Assignment

The following data structure and constraints exist for a magazine publishing company.

a. The company publishes one regional magazine each in Florida (FL), South Carolina (SC), Georgia (GA), and Tennessee (TN)

b. The company has 300,000 customers (subscribers) distributed throughout the four states listed in Part 2a.

c. On the first of each month, an annual subscription INVOICE is printed and sent to each customer whose subscription is due for renewal. The INVOICE entity contains a REGION attribute to indicate the customer's state of residence (FL, SC, GA, TN):

CUSTOMER (CUS_NUM, CUS_NAME, CUS_ADDRESS, CUS_CITY, CUS_STATE, CUS_ZIP, INVOICE (INV_NUM, INV_REGION, CUS_NUM, INV_DATE, INV_TOTAL)

The company is aware of the problems associated with centralized management and has decided that it is time to decentralize the management of the subscriptions in its four regional subsidiaries.

Each subscription site will handle its own customer and invoice data. The management at company headquarters, however, will have access to customer and invoice data to generate annual reports and to issue ad hoc queries, such as:

List all current customers by region.

List all new customers by region.

Report all invoices by customer and by region.

Given these requirements, how must you partition the database?

Reference no: EM132279274

Questions Cloud

Why sanctions are so powerful in maintaining social order : How do sanctions work? Why are they so effective in maintaining social order? To address these questions, you will violate a social folkway. Select one of the.

Writing a report to assess the validity of a new brief : In this assessment, you will be writing a report (

What should mark have done if jack still was not resolve : Would it make sense for Mark to assign this problem to someone else now, after Jack could not solve the problem the second time around?

Define brown factor in potential regulation : How should Brown factor in potential regulation into his investment thesis? The response must be typed, single spaced.

List all new customers by region : Report all invoices by customer and by region. Given these requirements, how must you partition the database?

Describe the key elements of the disaster recovery plan : Describe the key elements of the Disaster Recovery Plan to be used in case of a disaster and the plan for testing the DRP.

Explain the elements and principles of art : Considering the elements and principles of art discussed in this course, perform a visual analysis of your selected artwork. How does the artist represent the.

What is network management : For your citation, you might use articles that show examples of network management, network management tools and practices, and network vulnerabilities.

Instrumental model of corporate management : What is the instrumental model of corporate management? What is the social contract model of corporate management?

User Account

All Pages

List all new customers by region

Reference no: EM132279274

Reference no: EM132279274

Questions Cloud

Reviews

Write a Review

Management Information Sys Questions & Answers

Information technology and the changing fabric

Case study: software-as-a-service goes mainstream

Research proposal on cloud computing

Host an e-commerce site for a small start-up company

How are internet technologies affecting the structure

Segregation of duties in the personal computing environment

Social media strategy implementation and evaluation

Problems in the personal computing environment

Role of it/is in an organisation

Perky pies

Mark the equilibrium price and quantity

Visit and analyze the company-specific web-site

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT