Databases | SQL | Oracle | MS Access Answers

Orchid bank is a private sector bank which has branches in different countries. Orchid bank uses database for the storage of clients’ data because databases can store very large numbers of records efficiently. By using database, we can add, edit or delete data easily. It is more efficient in data searching and data sorting. Database can be used by more than one user to access same data simultaneously.

As a database designer, which type of database (distributed database & centralized database) you will use in this scenario to ensure data consistency, easy management and easy backup?

Also, what you think that replication of database suitable in the above given scenario?

Orchid bank is a private sector bank which has branches in different countries. Orchid bank uses database for the storage of clients’ data because databases can store very large numbers of records efficiently. By using database, we can add, edit or delete data easily. It is more efficient in data searching and data sorting. Database can be used by more than one user to access same data simultaneously.

As a database designer, which type of database (distributed database & centralized database) you will use in this scenario to ensure data consistency, easy management and easy backup?

Also, what you think that replication of database suitable in the above given scenario?

Create a data sheet in MS Access which includes Employee ID, Employee Name, Father Name, Gender (Male, Female), Age, Date of Joining (dd-mm-yyyy), Address, Cell number (0300-0000000) and City (Karachi, Islamabad, Lahore). 

Q.3. Develop an ER diagram for Salat management system     (5 marks)

An analyst investigating University Student course registration system has found the following rules are applied by registration department:

All applications for course registrations received by the campus are checked by student affairs department. Student affairs first checks the pre requisite of the selected courses for each application and adds that credit to the student's fee balance. If the credit hour exceeds the limit defined for that program, student's application is rejected and is intimated to reselect the courses as per defined limit of credit hours. All such students who have selected the courses according to university policy their fee voucher is generated and that the fee voucher has been passed to the accounts manager who will contact them in the next three days. After the payment of fee, confirmation is to be sent by accounts manager through SMS. In case fee voucher is generated and is not collected by the student reminder message is sent reminding the student of the payment of fees. Construct a Decision Table for the described process.  

Q.4. Answer the following as SQL queries. Also write corresponding relational algebra expression:     (15 marks)

a. Number of rakats prayed as Qaza by each person

b. How many females have skipped fajar salah on 1st shawwal

c. How many salah are missed by Mr. Noman

d. Average time M. Noman takes for praying Isha Salah

e. Which salah is missed mostly by M. Saleem

f. Which salah is missed the second most by all people

• Write a command to create a database named as “Salon – BC123456789” 
• Convert each ENTITY into Oracle Table (You have to write commands for each table along with proper constraints).  

Convert these queries to relational algebra expressions

a) select rackets

from Qaza

where NAME="A";

b) SELECT COUNT (name)

from female

where question1=Null

c) SELECT Count(SALAH)

From SALAH

WHERE follow=false

d) select AVG(time)

from prayer

where name ="M.Noman"

e) SELECT name

from slalah

where repetation=max

f) select name

from salah

where repetation<max

Q.3. Develop an ER diagram for Salat management system

a)   Create a data sheet in MS Access which includes Employee ID, Employee Name, Father Name, Gender (Male, Female), Age, Date of Joining (dd-mm-yyyy), Address, Cell number (0300-0000000) and City (Karachi, Islamabad, Lahore).

b)   Also create its Form and add at least 2 record through the form and create the following queries:

·      List only those employees who belong to the city Karachi.

·      Show only the female employee in the employee table

There should be at least 12 to 15 record in the table.

Please reply as fast as possible