Question: a. Identify three potential users and design a subschema for each. Justify your design by explaining why each user needs access to the subschema data

a. Identify three potential users and design a subschema for each. Justify your design by
explaining why each user needs access to the subschema data elements.
b. Use Microsoft Access or some other relational database product to create the schema tables. Specify the primary key(s), foreign key(s), and other data for each table. Test your model by entering sample data in each table.

Step by Step Solution

★★★★★

3.50 Rating (183 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a To fill out a sales order the sales order entry clerk needs access to the following data Item numb... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1250-C-S-I-S(1347).docx

120 KBs Word File

Students Have Also Explored These Related Information systems Questions!

A three-table database design for the data in the spreadsheet in Figure 5-17 is as follows: Choir Member (Last Name, First Name, Email, Phone, Part) Musical Work (Name of Work, Composer) Check Out...

A three table database design for the data in the spreadsheet in Figure 5-15 is as follows: ChoirMember (LastName, FirstName, Email, Phone, Part) MusicalWork (NameOfWork, Composer) CheckOut...

For the following exercises, you will address problems and answer questions from management at TAL Distributors. You do not use the TAL Distributors database for any of these exercises. 1. While...

The following data elements comprise the conceptual-level schema for a database: Billing address Cost Credit limit Customer name Customer number Description Invoice number Item number Price Quantity...

Identify three potential users and design a subschema for each. Justify your design by explaining why each user needs access to the subschema data elements. - To fill out a sales order, the sales...

quantity sold shipping address terms Required a . Identify three potential users and design a subschema for each. Justify your design by explaining why each user needs access to the subschema data...

a. Identify three potential users and design a subschema for each. Justify your design by explaining why each user needs access to the subschema data elements. - To fill out a sales order, the sales...

4.1 The following data elements comprise the conceptual-level schema for a database: billing address cost credit limit customer name customer number description invoice number item number price...

As executive director of the state forestry commission, in what way and how frequently would you evaluate the organizations strategies?

a. Distinguish between description and inference as reasons for using statistics. Illustrate the distinction using an example. b. You have data for a population, such as obtained in a census. Explain...

How are the materials and labor variances treated at the end of the year if they are not material?

1. 3.2 Suppose that the market demand for general physicians (GPs) per 1,000 people is given by Q = 5.07p-0.19 for p [0, 1000], Q = 0 otherwise and the market supply of GPs per 1,000 people is given...

Compare the guidelines for preparing flowcharts and DFDs. What general design principles and limitations are common to both documentation techniques?

Your classmate asks you to explain flowcharting conventions using real-world examples. Draw each of the major flowchart symbols from memory, placing them into one of four categories: input/output,...

Prepare flowcharting segments for each of the following operations: A. Processing transactions stored on magnetic tape to update a master file stored on magnetic tape. B. Processing transactions...

2017 estments 9 10 1:29:52 Finish atten -2 Suppose XYZinc, has a current dividend of D0 - $6, which is expected to shrink at the rate of 1-10L for 12 years. After that it will grow at the rate of 12...

Problem 11-22 Portfolio Returns and Deviations Consider the following information about three stocks: Rate of Return if State Occurs State of Probability of Economy State of Economy Stock A Stock B...

For both ink - jet and laser printers resolution is measured in . RPGCLTBKSDPI