Reference no: EM131172463
Suppose you are given the James River Jewelry database design as follows:
CUSTOMER ( CustomerID, LastName, FirstName, Phone, Email)
PURCHASE ( InvoiceNumber, Date, PreTaxAmount, CustomerID)
PURCHASE_ITEM ( InvoiceNumber , ItemNumber, RetailPrice)
ITEM ( ItemNumber, Description, Cost, ArtistName)
OWNER ( OwnerID, Name, Phone, Email, AmountOwed)
JEWELRY_ITEM ( ItemNumber, DateReceived, DateSold, NegotiatedSalesPrice, ActualSalesPrice, CommissionPercentage, OwnerID)
where
CustomerID in PURCHASE must exist in CustomerID in CUSTOMER
InvoiceNumber in PURCHASE_ITEM must exist in InvoiceNumber in PURCHASE
ItemNumber in PURCHASE_ITEM must exist in ItemNumber in ITEM
OwnerID in JEWELRY_ITEM must exist in OwnerID in OWNER
ItemNumber in JEWELRY_ITEM must exist in ItemNumber in ITEM
The OWNER and JEWELRY_ITEM tables are used to record data and maintain owner data about jewelry accepted on consignment. JEWELRY_ITEM (which is a subtype of ITEM-n ote the referential integrity constraint) is used to record the negotiated sales price, the commission percentage, and the actual sales price for each item of consigned jewelry.
Assume that office personnel at James River Jewelry use a database application to record consignment data.
• When an item is received on consignment, owner data are stored in OWNER if the owner is new; otherwise existing owner data are used. New ITEM and JEWELRY_ITEM rows are created. In ITEM, ItemNumber and Description are recorded, Cost is set to $0.00, and if there is an artist associated with the piece, ArtistName is entered. For JEWELRY_ITEM, data are stored for all columns except DateSold and ActualSalesPrice. James River Jewelry personnel refer to these actions as an Acceptance Transaction.
• Later, if the jewelry item does not sell, the NegotiatedSalesPrice and CommissionPercentage values may be reduced. This is called a Price Adjustment Transaction.
• Finally, when an item sells, the DateSold and ActualSalesPrice fields for the item are given values, and the AmountOwed value in OWNER is updated by increasing AmountOwed by the owner's percentage of the ActualSalesPrice value. This third transaction is called a Sales
Transaction
Suppose James River Jewelry identifies three groups of users: managers, administrative personnel, and system administrators. Suppose further that managers and administrative personnel can perform Acceptance Transactions and Sales Transactions, but only managers can perform Price Adjustment Transactions.
James River Jewelry has developed the following procedure for backup and recovery. The company backs up the database from the server to a second computer on its network each night. Once a month, it copies the database to a CD and stores it at a manager's house. It keeps paper records of all services provided for an entire year. If it ever loses its database, it plans to restore it from a backup and reprocess all service requests.
1 Which of the three application transactions must be made atomic (e.g., specify transaction boundaries) to prevent possible lost update? Why and why not?
2 Describe processing rights that you think would be appropriate for the identified three groups of company users.
Comment on the company's strategy on DB backup and recovery. Describe any changes you think the company should make to its current backup and recovery scheme.
Decline of organized labor political clout over recent
: Commentators often remark on the relative decline of organized labor's political clout over recent decades. Yet from recent big city mayor's races such as those in Boston and New York to national campaigns to raise the minimum wage, labor unions c..
|
Give opinion on whether or not you believe killing of laden
: Give your opinion on whether or not you believe the killing of Osama Bin Laden has negatively affected Al Qaeda and the Global War on Terrorism (GWOT). Use examples of such effects to support your position.
|
Strategic decision-making process
: Go through the media piece Bird Flu Case Study: Strategic Decision-Making Process and track your choices and the outcomes. Post a summary of your experiences in the case study that addresses the following:
|
Locate a case where acid rain has adversely affected a lake
: Sulfur dioxide and nitrogen dioxide form an acidic compound in the atmosphere.- Locate a case where acid rain has adversely affected a lake in either Vermont or New Hampshire.
|
Which of three application transactions must be made atomic
: Which of the three application transactions must be made atomic (e.g., specify transaction boundaries) to prevent possible lost update? Why and why not? Describe processing rights that you think would be appropriate for the identified three groups ..
|
Analyze government role in the protection of the environment
: Analyze the government's role in the protection of the environment. Be sure that your analysis includes a look at one of the following: conservation, environmentalism, protection, global warming, and energy concerns.
|
Discuss financial statement by using triple bottom line
: In this assignment need to take one company like apple company we can take example of iphone 6 or 6 plus, market size of that product, revenue of that product, how many people liked that product and use this product and their competitor in the mar..
|
Research for the environmental problems
: Do you feel that lobbyists and special interest groups exert too great of an influence and act as an impediment to finding solutions to, and providing the funding for, research for the environmental problems we face?
|
Discuss the ways employers lose nlrb elections
: Discuss the ways employers lose NLRB elections. Describe how the acronym T.I.P.S. can assist supervisors in remembering what not to do during campaigns.
|