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

Data mining assignment -in this assignment you are asked to

Data Mining Assignment - In this assignment you are asked to explore the use of neural networks for classification and numeric prediction. You are also asked to carry out a data mining investigation on a real-world data ...

Sql query assignment -for this assignment you are to write

SQL Query Assignment - For this assignment you are to write your answers in a word document. This assignment is in three parts: Part A (reporting queries), Part B (query performance), Part C (query design). For this assi ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

Objectivethe objective of this lab is to be familiar with a

OBJECTIVE: The objective of this lab is to be familiar with a process in big data modeling. You're required to produce three big data models using the MS PowerPoint software. This tool is available on UMUC Virtual Deskto ...

The relation memberstudentid organizationid roleid stores

The relation Member(StudentId, OrganizationId, RoleId) stores the membership information of student joining organization. For example, ('S1', 'O2', 'R3') indicates that student with Id 'S1' joined the organization with i ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Relational database design a given the following business

Relational Database Design A) Given the following business rules, identify entity types, attributes (at least two attributes for each entity, including the primary key) and relationships, and then draw an Entity-Relation ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

  • 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

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As