Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Project: Choose one of the following problems to answer. Post your response to this week's discussion forum at least two days before the end of the week. Read all postings and respond to at least two.

Suppose your database system has failed. Describe the database recovery process and the use of deferred-prepare and prepare-through techniques.

Suppose you are asked to evaluate a DBMS in terms of lock granularity and the different locking levels. Create a simple database environment in which these features would be important.

Research the Dining Philosophers problem on the Internet. Summarize what you find and describe how this classic problem relates to deadlock and concurrency control. describe how you could prevent this problem from occurring.

There are several different kinds of locks used with databases. Using your text, the Internet, and any other sources you have available, study the concept of locking. Briefly describe each type of lock that you uncover during your studies, along with its advantages and disadvantages.

prepare or find (online) SQL statements that might be used in transaction management and describe how they work. Here's an ex with the answer:

The following transaction registers the credit sale of a product to a customer. Start transaction

INSERT INTO INVOICE -- Add record to invoice

(INV_NUM, INV_DATE, ACCNUM, TOTAL)

UPDATE INVENTRY -- Update the quantity on hand of the product

SET ON_HAND = ON_HAND - 100

WHERE PROD_CODE = '345TYX';

UPDATE ACCREC -- Update the customer balance account

The above statement have accomplished:

 

Create the invoice record.

Update the inventory data.

Update the customer account data.

The DBMS will ensure that all SQL statements are executed and completed before committing all work. If, for any reason, one or more of the SQL statements in the transaction cannot be completed, the entire transaction is aborted and the database is rolled back to its previous consistent state.

Project: Make sure that your E-R diagram and your data dictionary are accurate in every detail. (Entities and attributes are the same.)

Use the group E-R diagram and data dictionary from the previous two weeks to develop SQL statements that will create tables.

After your tables are created, enter a minimum of 3 sets of data for each table.

Use the SQL exs from the last two weeks and anything you can find on the Internet as exs on how to prepare the SQL instructions.

Attach your SQL code for creating the tables and adding data to each table to this assignment in a single text document.  Post your the ERD and Data Dictionary that you use to generate your code to your file exchange.

Note: The attached pvfc1.txt file used in week 1 is an ex of what you code should look like.  Except that your code should include comments for each block of text.


Attachment:- TG14 Assignment.zip

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M914435
  • Price:- $70

Priced at Now at $70, Verified Solution

Have any Question? 


Related Questions in DBMS

Relational database systems comp 1005objective this is an

Relational Database Systems (COMP 1005) Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scen ...

Analytical assignment individual or group of max two

Analytical Assignment (Individual or Group of Max two students) What is Research article? Review articles provides summary of current state of the research on a particular topic. Ideally, the writer searches for everythi ...

The discussion questionbased on your research and readings

The discussion question Based on your research and readings for the week, respond to the following discussion topics. • Often, systems have only one level of security when it comes to databases. Imagine that someone is t ...

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

Frontlines united states of secrets all Frontline's United States of Secrets, all

Frontline's United States of Secrets, all episodes: http://www.pbs.org/wgbh/frontline/film/united-states-of-secrets/ (Links to an external site.) Nova's Genome specials http://www.pbs.org/wgbh/nova/body/cracking-the-code ...

Assignmentthis must be your own unique work you cannot have

Assignment THIS MUST BE YOUR OWN UNIQUE WORK: you cannot have the exact same table as another student and you cannot turn in something you find online!Your work will be checked against a plagiarism database. The format m ...

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

Hospital database determining keysdevelop a microsoft

Hospital Database: Determining Keys Develop a Microsoft Access database based upon the following business scenario. Be sure to include tables, fields, keys, relationships, and test data in your database. Your final submi ...

Assignment - data mining and machine learning in the real

Assignment - Data Mining and Machine Learning in the Real World OBJECTIVE: Learn about some of the things going on in the real-world with Machine Learning and Data Mining. Your answers to the questions in the cells right ...

Assignment business rules and data modelssuppose a local

Assignment: Business Rules and Data Models Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and cour ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen