Please help me with (b) QUESTION 4The following data structure and constraints exist for a magazine publishing company.The company publishes one regional magazine each in Kwazulu-Natal (KZN),Mpumalanga (MP), Limpopo (LP), and Gauteng (GP).The company has 300,000 customers (subscribers) distributed throughout these fourprovinces.On the first of each month, an annual subscription INVOICE is printed and sent to eachcustomer whose subscription is due for renewal. The INVOICE entity contains a REGIONattribute to indicate the customer's province of residence (KZN, MP, LP, GP):CUSTOMER (CUS NUM, CUS_NAME, CUS_ADDRESS, CUS_CITY, CUS_PROVINCE, CUS_ZIP,CUS SUBSDATE)INVOICE (INV NUM, INV_REGION, CUS_NUM, INV_DATE, INV_TOTAL)The company is aware of the problems associated with centralized management and has decidedthat 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 companyheadquarters, however, will have access to customer and invoice data to generate annual reportsand 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.a) What recommendations will you make regarding the type and characteristics of the requireddatabase system?b) Suppose the database is to be horizontally partitioned, using the PROVINCE attribute for theCUSTOMER table and the REGION attribute for the INVOICE table, design the databasefragments. Show an example with node names, location, fragment names, attribute names, anddemonstration data.

list all current customer by region SELECT * FROM CUSTOMER WHERE REGION ORDER BY CUS_ID;

Answered: List all current customers by region.…

Engineering

Computer Science

List all current customers by region. List all new customers by region. Report all invoices by customer and by region.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Read the following scenario and answer the questions given bellow.• A car rental company has its offices in three major cites of the area. Acostumer once registered with the company, can avail its services from anynearby office. Every office keeps record of the vehicles, their drivers andrenting details. Salaries of administrative staff are controlled at a single sitewhile the drivers are paid (according to the services they provide) from their local office. Rates for famous tourism spots are fixed (with a slight difference for different vehicles), while other spots are charged according to the mileage covered. 1. Identify the entities involved in the database designed for thecompany.2. Draw GCS for the system.3. Give details of any of the relations replicated on more than one sites
Consider the following College and perform the task that follows.Ocean Sound College, a liberal arts college located on the West Coast, provides dormitory housing for approximately half of its students. Students who choose not to live on campus, or who do not get assigned dormitory space, must find housing in the surrounding community. Currently, the housing office uses a cumbersome system of multiple binders to keep track of housing opportunities for students, faculty, and staff of the college. Housing listings are for college-owned housing, housing owned by private parties including landlords and individuals looking for roommates. The current system is difficult to maintain and keep up-to-date. The new college president approved a request to fund the development of a system to provide easier access and maintenance of listings. You are the systems analyst assigned from the college IT department to conduct the initial investigation into the feasibility of such a system. The preliminary…
In the following criteria, provide some instances of how they may be restated using quantitative language. You are free to communicate the requirements using whatever metrics that you like. 1 The circulation system at the library has to be user-friendly.2 The library system is responsible for providing uniform service to all patrons.3 The library system is required to provide prompt responses to any inquiries made by patrons for book information.
E8.4 Consider the following scenario involving Pineview Ford, an auto dealership. Auto dealership Pineview Ford is organized as follows: • Pineview Ford keeps track of Vehicle Identification number of every vehicle that is for sale, sold, serviced, or rented by the dealership. • Vehicles are sold via a sale transaction. One transaction involves one sales person, one client, and one vehicle. • Vehicles are serviced via a service transaction. One transaction involves one service person, one client, and one vehicle. • In addition to selling and servicing vehicles, Pineview Ford occasionally rents vehicles. One rental transaction involves one rental agent, one client, and one vehicle. Pineview Ford wants to create the analytical database (data warehouse) to analyze their revenue. The two available data sources, Source 1 and Source 2, are described below. Source 1 Pineview Sales and Service Database Source 2 Pineview Rental Log The data warehouse has to enable an analysis of revenue by…
E8.4 Consider the following scenario involving Pineview Ford, an auto dealership. Auto dealership Pineview Ford is organized as follows: • Pineview Ford keeps track of Vehicle Identification number of every vehicle that is for sale, sold, serviced, or rented by the dealership. • Vehicles are sold via a sale transaction. One transaction involves one sales person, one client, and one vehicle. • Vehicles are serviced via a service transaction. One transaction involves one service person, one client, and one vehicle. • In addition to selling and servicing vehicles, Pineview Ford occasionally rents vehicles. One rental transaction involves one rental agent, one client, and one vehicle. Pineview Ford wants to create the analytical database (data warehouse) to analyze their revenue. The two available data sources, Source 1 and Source 2, are described below. Source 1 Pineview Sales and Service Database Source 2 Pineview Rental Log The data warehouse has to enable an analysis of revenue by…
Q4) Find the boundary condition that makes the following two ambulance dispatching system requirements strongly conflicting. (Patient's viewpoint) "The free ambulance nearest to the incident scene should be dispatched" And (driver's viewpoint) "Ambulances should keep close to their station". How would you modify the requirements so that they would not conflict?
Question 2:In the University library every 5 minutes a student arrives arrives. The librarian takes 3 minutesto serve student. Complete the following table (for 10 students) and calculate the averagetime a student spends in the system, arrival rate, service rate and percentage idle time of server.(Assume the first student arrives at 8:00 A.M and service begin immediately).
Using the table, either buying a network of PCs for a department at your workplace or outfitting a laboratory of PCs for students at a university, conduct a multicriteria analysis that contrasts at least three alternative configurations with at least three different requirements and three different constraint criteria
When analyzing areas surrounding (or ‘near’) a location (such as a school) for demographic characteristics (such as number of persons of school age, or median household income), there are a variety of choices to define what ‘near’ should be. Two of the most common ways to do this with vector analysis are to use a ‘buffer’ (such as a 1-mile buffer) or a network ‘service area’ (such as a 4-minute drive-time). If you were asked to analyze an area surrounding (‘near to’) existing Health Clinic locations (somewhere in the US) for information on the number of households and income of those households, what is the level of geographic detail and type (or source) of data that you would likely use to obtain the demographic information? Would you choose to use a ‘buffer’ or a ‘network service area’ (or another choice) to define the area ‘near’ the Emergency Rooms? Why? After defining and creating the “near” area, what analysis operation would get the information from the demographic data layer…
a) Suppose that You have gotten a job planning databases for the European Union. Yourfirst on job assignment is to help the various countries maintain information about theirinhabitants. Your model should capture the following information:• In each country, there are provinces, which contain towns. There cannot be twoprovinces with the same name in a single country. Similarly, there cannot be two townswith the same name in a single province.• People live in towns. Men and women work in a town. Children learn in a school in atown.• A person can be a man, a woman, or a child, and has a first-name, last-name, id, andbirthday.Children are any people under the age of 18.• A man can be married to a woman (polygamy is not allowed, i.e., one man can bemarried only to one woman). Although the Pope strongly disapproves, divorce, andsubsequent remarriage, is possible.• For each marriage, store the date of the marriage and information about who are thechildren of the married couple. You should…
Consider the following list of requirements related to a large enterprise with several companies, for which you are required to come up with an ER model. Each company operates four departments, and each department belongs to one company. Each department in part (a) employs one or more employees, and each employee works for one department. Each of the employees in part (b) may or may not have one or more dependents and each dependent belongs to one employee. Each employee in part (c) may or may not have an employment history, which includes his employments until the employee joined this enterprise as well as the employment history within the enterprise (after joining). Which of the following statements are true about the ER diagram (assuming it is a good design)? Employment history will be a weak entity. There will be a many-to-many relationship between company and employee. The relationship between department and employee will be optional for department
As a large service organization, King Abdullh University Hospital depends on a large number of persons for its continued success. There are four groups of persons on whom the hospital is most dependent: employees, physicians, patients, and volunteers. Of course some common attributes are shared by all of these persons: Person_ID (identifier), Name, Address, Ciy/State/Zip, Birth_Date, and Phone. Each of the four groups of persons has at least one unique attribute of its own. Employees have a Date_Hired, Volunteers have a Skill, Physicians have a Specialty and a Pager# (pager number), and Patients have a Contact_Date (date of first contact with the hospital). Some other persons in the hospital community do not belong to one of these four groups (their numbers are relatively small). However, a particular person may belong to two (or more) of these groups at a given time (for example, Patient and Volunteer). Each patient has one (and one only) physician responsible for that patient. A…