Project #88853 - Homework #3

http://www.wikiupload.com/NI21X1I3BQMTHMV (database)

  1. Describe the Lost update problem in a DBMS and give an example of it (2pts).

 

 

 

 

  1. Use the Database Design Language (DBDL) to define the following tables in the Solmaris database. Please be detailed about identifying all the components (3pts).

 

Tables: CondoUnit, Location, Owner, ServiceRequest, ServiceCategory

 

 

  1. A database at a college is required to support the following requirements. Complete the information-level design for this set of requirements. Use your own experience to determine any constraints you need that are not stated in the problem. Represent your answer in DBDL. (4pts)

    1. For a department, store its number and name.

    2. For an advisor, store his or her number and name and the number of the department to which he or she is assigned.

    3. For a course, store its code and description (for example, MTH110 or Algebra).

    4. For a student, store his or her number and name. For each course the student has taken, store the course code, course description, and grade received. In addition, store the number and name of the student’s advisor. Assume that an advisor may advise any number of students but that each student has just one advisor.

 

 

 

 

 

 

 

 

  1. Create an ER Diagram for the following database information. Be sure to include the proper notation (6 pts):

    1. Employees have the following attributes: Employee Number, First Name, Last Name, Address , City, state Zip Code and each employee can have multiple jobs that have the attributes: job id, job description, pay class, and cost center. Each job can also be assigned to multiple employees.

    2. In addition, each employee can also have multiple paycheck earnings which have the attributes: earning code, earning description and Is Taxable. Each earning can be assigned to multiple employees.

 

 

 

 

 

  1. List and Describe 4 functions of a DBMS (2pts).

 

 

 

 

 

 

  1. In order to manage concurrent updates, a DBMS will implement Two-Phase Locking (2pts).

    1. What is two-phase locking and what are the phases involved.

 

 

 

    1. Provide an example of two phase locking.

 

 

  1. Provide a detailed diagram of the following sequence:

 

Tom is going to update record X as after lunch at 1pm. However, Jane is also updating record X, but she begins her update at 12:58pm and will take 4 minutes to complete. What will occur to Tom at 1pm? At 1:05pm? (3pts)

 

 

 

 

 

 

 

 

 

 

 

  1. Describe the process of journaling in a database and describe how it is used to recover data (3pts).

 

 

 

 

Subject Computer
Due By (Pacific Time) 10/31/2015 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy