Describe in detail what steps to be taken to add the new columns from Question 5 to
Question:
Describe in detail what steps to be taken to add the new columns from Question 5 to the Supplier table. How much down time/maintenance time is required?
Question 5
The Supplier table in Figure 3.2 has a minimal amount of information. What columns do you recommend be added?
Transcribed Image Text:
Customer **CustomerIdentifier Customer TelephoneNumber CustomerName CustomerStreetAddress CustomerCity CustomerState CustomerZipCode CustomerCredit Rating CustPreferredCredit Card Order **OrderNumber Customeridentifer Ordered Item **OrderNumber **ItemNumber OrderDate Shipping Street Address Shipping City Shipping State Credit Card **Customer Credit CardNumber Customer Credit CardName Advertised Item **ItemNumber ItemDescription ItemDepartment Item Weight ItemColor ItemPrice LowestPrice LowestPriceSupplier QuantityOrdered Selling Price ItemShipping Date ShippingZipCode CustomerCredit CardNumber OrderShippingDate Order TotalCost CustomerIdentifier PreferredOption FIGURE 3.2 The physical data model. Supplier **SupplierID Supplier Name Supplier Street Address SupplierCity Supplier State Supplier ZipCode Restock_Item **SupplierID **ItemNumber ReorderPrice
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (2 reviews)
If using Microsoft Access Open the database to the Tables section and s...View the full answer
Answered By
Jinah Patricia Padilla
Had an experience as an external auditor in Ernst & Young Philippines and currently a Corporate Accountant in a consultancy company providing manpower to a 5-star hotel in Makati, Philippines, Makati Diamond Residences
5.00+
120+ Reviews
150+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer science questions
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Q3. Modulus of rupture of concrete is a measure of a) flexural tensile strength b) direct tensile strength c) compressive strength d) split tensile strength Q4. For a longitudinal reinforcing bar in...
-
What is the difference between a linear and a non-linear cost function? Give an example of each type of cost function.
-
Refer to Exercise, where the statistics practitioner estimated the size of market segments based on education among California adults. Suppose that census figures from 10 years ago showed the...
-
How should we test components?
-
In December 2010, Ultravision established its predetermined overhead rate for movies produced during year 2011 by using the following cost predictions: overhead costs, $1,800,000, and direct labor...
-
The York City Hospital has just acquired new equipment. The equipment cost $ 4 , 2 5 0 , 0 0 0 , and the organization spent $ 1 3 5 , 0 0 0 on upgrading the physical plant to the new equipment will...
-
Using the physical data model in Figure 3.2, describe the sequence of tables to be accessed to show all information regarding a customer order and all items on that order. Customer...
-
As part of the changes made for Question 3, are any changes to Referential Integrity constraints needed? Why or why not? Question 3 If the physical data model is to be expanded to include information...
-
A function f : X Y is linear if and only if f (1x1 + 2x2) = 1f(x1) + 2f(x2) for all x1, x2 X, and 1, 2 .
-
Research two cases related to fingerprint analysis - one that supports its validity for identification and one that calls it into question. Compare and contrast the two cases and discuss what factors...
-
What impact does fair cross-section have on the criminal justice system, and are there more organizations than courts affected by this and the different branches of the criminal justice system?
-
Select a criminal justice program that would be subject to evaluation. It can be from any state, local, or federal organization. Describe the criminal justice program you selected. Identify the...
-
How do theories of social identity and group dynamics inform our understanding of intractable conflicts, exploring the role of collective identities, group cohesion, and intergroup relations in...
-
How do conflict resolution practitioners apply principles of restorative justice and transformative mediation to facilitate reconciliation, healing, and constructive dialogue among individuals and...
-
Suppose your client says, I am invested in Japanese stocks but want to eliminate my exposure to this market for a period of time. Can I accomplish this without the cost and inconvenience of selling...
-
Subtract the polynomials. (-x+x-5) - (x-x + 5)
-
Implement the containKey(k) method, as described in Exercise R-10.3, for the SortedTableClass.
-
Consider lines 3133 of Code Fragment 10.8 in our implementation of the class ChainHashMap. We use the difference in the size of a secondary bucket before and after a call to bucket.remove(k) to...
-
Modify the Pair class from Code Fragment 2.17 on page 92 so that it provides a natural definition for both the equals( ) and hashCode( ) methods.
-
1. The displacement (in meters) of an object at time t is given by f(t) = 12-21 where t is measured in seconds. a. Find the average velocity between t = 2.001 and t = 2. (2) b. Find the average...
-
(1) What is the resonance condition? (5 points) (2) Prove the following relationship (15 points): R(a) = R(-a) = R(a) (3) Calculate and sketch B,rot (t) assuming that (25 points) B(t) = B cos(wrft...
-
3. A 1,000 kW, 60 Hz, eight-pole synchronous motor has a rated terminal voltage of 4,200 V, RMS, line-line. It has a field to phase mutual inductance of M = 182 mH, a direct axis synchronous...
Study smarter with the SolutionInn App