CAT 2 - CAT PDF

Title	CAT 2 - CAT
Author	Anonymous User
Course	Introduction and anatomy of upper and lower limb
Institution	Kabarak University
Pages	2
File Size	181.2 KB
File Type	PDF
Total Downloads	98
Total Views	178

Preview

CLICK TO PREVIEW PDF

Summary

CAT...

Description

STRATHMORE INSTITUTE DIPLOMA IN BUSINESS INFORMATION TECHNOLOGY DBT 1203: DATABASE SYSTEMS CAT 2 Date: 4th AUGUST 2020

1 Hour (20 Marks)

INSTRUCTIONS  Answer ALL Questions  Write your responses legibly on foolscap . Include your name and Student Number on each page.  Once done, scan your work (AS A SINGLE FILE) on the CamScanner App or any other scanning tool.  Upload your scanned ‘pdf’’ answers on the link provided (E-learning)  Submission must be online within the allocated time  Late submission of the CAT will not be graded. a) Using SQL query example, differentiate between Data Manipulation Language and Data Definition Language (2 Marks) b) Given the following XYZ company database: CUSTOMER CUST_NO

CUST_LNAME

CUST_FNAME

BALANCE

1000

SMITH

JANE

10000

1001

NJOROGE

MIKE

20000

INVOICE

INV_NO

CUST_NO

INV_DATE

INV_AMOUNT

8000

1000

23-Mar-2015

345.3

8001

1001

23-Mar-2015

566.7

8002

1001

30-Mar-2015

234.7

i. ii.

iii. iv. v.

8003

1000

12-April-2015

987.6

8004

1000

24-April-2015

765.5

Write a query that will show (for all the invoices) the invoice number, the invoice amount and the invoice date. (2 Marks) Write SQL query to modify the CUSTOMER table to included two new attributes: CUST_DOB and CUST_AGE. Customer 1000 was born on March 15, 1979, and customer 1001 was born on December 22, 1988. (3 Marks) Write a query to find the average of customers’ balance (2 Marks) List all invoices, showing invoice number, date, amount, and first name and last name of customer. (3 Marks) Write a query to retrieve customers’ name having AN in any position (1 Mark)

c) Transaction is an action, or series of actions, carried out by a single user or application

program, which reads or updates the contents of the database. Explain Four properties of a transaction (4 Marks) d) Two-phase locking defines how transactions acquire and relinquish locks. Discuss in detail the process of Two-phase locking as a concurrency control technique (3 Marks)...