Assignment: Introduction to Database
Question One
Compute the closure (F+) of the following set F of functional dependencies forrelation schema R(A, B, C, D, E).
A→BC
CD→E
B→D
E→A
List the candidate keys for R.
Question Two
Write the following queries in Relational Algebra, for the following bank schema:
account(ano,bname,balance)
branch(bname, bcity,assest)
customer(Cname, cstreet, ccity)
loan(lno,bname,amount)
deposit(cname,ano)
borrower(cname,ino)
a) Select all loan tuples where branch name is Abha.
b) Select all loan tuples where branch name is Abha and loan amount less than 200000.
Question Three
Using the above bank schema, find the Tuple Relational Calculus queries, for the following:
a) Find the loan with amount more than 150,000.
b) Find loan number for each loan of amount greater than 150,000
Question Four
Given the three tables below, write the following queries.
Customer
|
custNo
|
custName
|
custSt
|
custCity
|
age
|
|
1
|
C1
|
Olaya St
|
Jeddah
|
20
|
|
2
|
C2
|
Mains St
|
Riyadh
|
30
|
|
3
|
C3
|
Mains Rd
|
Riyadh
|
25
|
|
4
|
C4
|
Mains Rd
|
Dammam
|
|
|
5
|
C5
|
Mains Rd
|
Riyadh
|
|
Product
|
prodNo
|
prodName
|
prodDes
|
price
|
|
100
|
P0
|
Food
|
100
|
|
101
|
P1
|
healthy Food
|
100
|
|
102
|
P2
|
|
200
|
|
103
|
P3
|
self_raising flour,80%wheat
|
300
|
|
104
|
P4
|
network 80x
|
300
|
Order
|
ordNo
|
ordDate
|
custNo
|
prodNo
|
quantity
|
|
R03010101
|
01-jan-2003
|
C01
|
100
|
2
|
|
R03010203
|
02-jan-2003
|
C01
|
101
|
1
|
|
R03010102
|
01-jan-2003
|
C2
|
102
|
1
|
|
R03010103
|
01-jan-2003
|
C343
|
100
|
2
|
|
R03010301
|
03-jan-2003
|
C01
|
101
|
1
|
|
R03030601
|
06-mar-2003
|
C2
|
100
|
10
|
1. A DDL command to build order table, including all integrity constraints. Make sure that ordDate value exists and quantity value is always positive.
2. A DML command to answer: How many orders were made by customer C01 and how many products pieces did he order?
3. A DML command to list customers who have ordered the product 100. (Hint: use join)
4. A DML command to find products with price more than average (Hint: use nested queries)
Question Five
Describe Server-side Scripting and Client-side Scripting in detail. Also, discuss the key difference between Server-side Scripting and Client-side Scripting.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.