Chapter 12 Assignment - 2. The following data structure and...

This preview shows page 1 - 2 out of 4 pages.

The preview shows page 1 - 2 out of 4 pages.
2. 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 listedin Part a.c. On the first of each month an annual subscription INVOICE is printed and sent to all customerswhose subscription is due for renewal. The INVOICE entity contains a REGION attribute toindicate the state (FL, SC, GA, TN) in which the customer resides:CUSTOMER (CUS_NUM, CUS_NAME, CUS_ADDRESS, CUS_CITY, CUS_STATE,CUS_SUB_DATE)INVOICE (INV_NUM, REG_CODE, CUS_NUM, INV_DATE, INV_TOTAL)The company's management is aware of the problems associated with centralized managementand has decided that it is time to decentralize the management of the subscriptions in its fourregional subsidiaries. Each subscription site will handle its own customer and invoice data. Thecompany's management, however, wants to have access to customer and invoice data to generate

Upload your study docs or become a

Course Hero member to access this document

We have textbook solutions for you!
/Database-Systems-Design-Implementation-Management-13th-Edition-9781337627900-625/
The document you are viewing contains questions related to this textbook.
Chapter 3 / Exercise 4
Database Systems: Design, Implementation, & Management
Coronel/Morris
Expert Verified

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 4 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
Bailey
Tags
Humid subtropical climate, Database management system
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Database Systems: Design, Implementation, & Management
The document you are viewing contains questions related to this textbook.
Chapter 3 / Exercise 4
Database Systems: Design, Implementation, & Management
Coronel/Morris
Expert Verified

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture