assume that marcia has hired you as a database consultant

Project Description:

assume that marcia has hired you as a database consultant to develop an operational database having the following four tables (the same tables described at the end of chapter 7):customer (customerid, firstname, lastname, phone, email)invoice (invoicenumber, customerid, datein, dateout, subtotal, tax, totalamount)invoice_item (invoicenumber, itemnumber, serviceid, quantity, unitprice, extendedprice)service (serviceid, servicedescription, unitprice)a. assume that marcia’s has the following personnel: two owners, a shift manager, a part-time seamstress, and two salesclerks. prepare a two- to three-page memo that addresses the following points:1. the need for database administration.2. your recommendation as to who should serve as database administrator. assume that marcia’s is not sufficiently large to need or afford a full-time database administrator. 3. using figure 9-1 as a guide, describe the nature of database administration activities at marcia’s. as an aggressive consultant, keep in mind that you can recommend yourself for performing some of the dba functions.b. for the employees described in part a, define users, groups, and permissions on data in these four tables. use the security scheme shown in figure 9-13 as an example. create a table like that in figure 9-12. don’t forget to include yourself.c. suppose that you are writing a stored procedure to create new records in service for new services that marcia’s will perform. suppose that you know that while your procedure is running another stored procedure that records new or modifies existing customer orders and order line items can also be running. additionally, suppose that a third stored procedure that records new customer data also can be running.1. give an example of a dirty read, a nonrepeatable read, and a phantom read among this group of stored procedures.2. what concurrency control measures are appropriate for the stored procedure that you are creating?3. what concurrency control measures are appropriate for the two other stored procedures?
Skills Required:
Project Stats:

Price Type: Negotiable

Total Proposals: 10
1 Current viewersl
150 Total views
Project posted by:


Proposals Reputation Price offered
  • 4.7
    48 Jobs 26 Reviews
    $0 in 0 Day
  • 4.0
    72 Jobs 31 Reviews
    $0 in 0 Day
  • 4.9
    2550 Jobs 1276 Reviews
    $0 in 0 Day
  • 3.8
    30 Jobs 19 Reviews
    $0 in 0 Day
  • 4.9
    7 Jobs 7 Reviews
    $0 in 0 Day
  • 4.8
    60 Jobs 32 Reviews
    $0 in 0 Day
  • 4.9
    95 Jobs 45 Reviews
    $0 in 0 Day