Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1)a) Describe Advantages and disadvantages of Hierarchical Data Model and Network Data Model.

b) describe the levels of Data Abstraction in DBMS.

problem 2)a) describe Query Processor and Storage manager components of DBMS.

b) Describe advantages and disadvantages of DBMS approach.

problem 3)a) Consider University database which keeps track of students, their majors, their transcripts and their registrations, as well as of the university's course offerings. The database also keeps track of the sponsored research projects of faculty and graduate students. Draw the E-R Diagram which must be consist of Entity sets, attributes, relationships, mapping cardinality and keys.

b) Describe strong entity set and weak entity set in detail.

problem 4)a) Draw ER Diagram for Banking enterprises which must be consist of Entity sets, attributes, relationships, mapping cardinality and keys, aggregation, specialization, Role and Generalization.

b) Describe the constrains on Generalization in EER.

problem 5)a) What do extension and Intentions of relations mean.

b) Describe SQL Sequence and View Object.

c) Describe codd's comprehensive sub-language rule and data independence rule.

problem 6)a) Describe different keys used in relational model and Domain Constraints with suitable ex.

b) Describe database languages with suitable ex

problem 7)a) Consider the following Relations. It defines the schema of the database application for a library.

BOOK (Book_ISBN[pk], Title, Publisher_Name[fk])
BOOK_AUTHORS (Book_ISBN [pk,fk], Author_Name[pk])
PUBLISHER (Name [pk], Address, Phone)
BOOK_COPIES (Book_ ISBN [pk,fk], Branch_ID [pk,fk],Num_ Copies)
BOOK_LOANS (Book_ISBN[pk,fk], Branch_ID [pk,fk], Card_Num[pk,fk], Date_Out, Date_Due)
LIBRARY_BRANCH (Branch_ID [pk], Branch_Name, Address)
BORROWER (Card_Num[pk], Name, Address, Phone)

Answer the following queries in each of the SQL query languages that you know:

i) List all the ISBN and title of all books written by "John Smith".

ii) List all the ISBN and title of all books written by "John Smith" as the only author.

iii) List all the Card number and name of all borrowers who checked out two or more books on 10/16/2003.

iv) List all the branch ID and name of all library branches that have at least one copy of all the books.

v) List all the card number and name of borrowers who check out books from the LPL03 branch.

vi) List all the names of authors who use only one publisher.

vii) List all the names of authors and count of the number of books they have published. The list will be in descending order by the number of books.

viii) List all the ISBN, title and publisher of all books that have the word "Louisiana" in the title.

ix) List all the card number and name of the borrower who has checked out the most books.

x) For each branch list the branch ID and the number of books they have. This is the total number of books including multiple copies.

b) describe sub query in SQL.

problem 8)a) The HRD manager has decided to raise the salary for all the employees in department no. 20 by 0.05. Whenever any such raise is given to the employees a record for the same is maintained in the emp_raise table.
It includes the employee no, the date when the raise was given and the actual raise. prepare a PL/SQL block to update the salary of each employee and insert a record in the emp_raise table, create employee and department table.

b) prepare brief notes on Assertion and Database Triggers.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M95583

Have any Question? 


Related Questions in DBMS

Physical database design assignment query optimisationthis

Physical Database Design Assignment: Query Optimisation This assignment aims to develop your skills optimizing query. It involves identifying the suitable methods for structuring the data and writing the query. First, yo ...

The purpose of the veterinary hospital registration system

The purpose of the Veterinary Hospital Registration system is to handle and record all the information relating to the clients, veterinarians, pets, treatments administered, insurance coverage and appointments (open, clo ...

Database design and development assignmentintroduction -

Database Design and Development Assignment Introduction - The sample solution of assignment 1 will be released on the course website approximately two (2) weeks after the assignment 1 due date.  You must use that sample ...

Application creating and populating a databasesuppose you

Application: Creating and Populating a Database Suppose you have a small retail store and decide to create a database to track sales. You have information about recent sales that you want to use for testing the database. ...

Upload your final project code and your presentation upload

Upload your final project code and your presentation. Upload all of your code in one large text file that has the .sql extension. Be sure to identify each section of code so that the reader will know what it does. All co ...

1 what is the difference between a column constraint and a

1. What is the difference between a column constraint and a table constraint? 2. What is a recursive join? 3. Explain the difference between an ORDER BY clause and a GROUP BY clause. 4. What is a CROSS JOIN? Give an exam ...

Database worksheetuse the attached database to complete the

Database Worksheet Use the attached database to complete the following: Create a simple excel spreadsheet with data to update the database. >>> This can hold any type of data to be used in this database In MS Access 1. C ...

Data base 1 hypertensionobjective to determine whether or

Data Base 1: Hypertension Objective: To determine whether or not the community self-management program is effective to promote health and reduce blood pressure level in patients with hypertension Rationale In low-to-midd ...

Database design and use group assignmentassignment

Database Design and Use Group Assignment Assignment Description - In this assignment you will use your normalized "City Jail" database you have created in your assignment one. You will form a group (2-3 students) and imp ...

Systems and database design assignment database design amp

Systems and Database Design Assignment: Database Design & Implementation (Airline) The assignment consists of two tasks. The first task, Database Design, requires a word processed document in PDF format detailing the des ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate