Ask Question, Ask an Expert


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

Lab 2 modifying a database design in visiothis assignment

Lab 2: Modifying a Database Design in Visio This assignment contains two Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Use "Appendix A: ...

Database systems assignment - student enrolment database a

Database Systems Assignment - Student Enrolment Database A. Task Description 1. Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, de ...

Discussionatleast 1 paragraph for each partpart 1 remote

Discussion Atleast 1 paragraph for each part Part 1: "Remote Access" Please respond to the following: • Remote access to corporate resources is becoming commonplace. From an auditing perspective, suggest two or more cont ...

Individual outsourcing risksprepare a 8- to 10-slide

Individual: Outsourcing Risks Prepare a 8- to 10-slide PowerPoint presentation, including speaker notes, that identifies the possible risks to an organization in each of the following outsourcing situations: • The use of ...

Unlimited pickers is a group of workers who have joined

Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from location to l ...

Describe a dbms and its functions list at minimum three of

Describe a DBMS and its functions. List, at minimum, three of the popular DBMS products and give a brief description of each. Your response should be at least 200 words in length. Explain what mobile devices are and why ...

Normalizationsuppose that you are the database developer

Normalization Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcom ...

Advanced relational database final programming project in

Advanced Relational Database Final Programming Project In this project, you will design a secure database with several tables using good relational database design techniques. Project Objectives: After completing this Pr ...

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

Analytical assignment individual or group of max two

Analytical Assignment (Individual or Group of Max two students) What is Research article? Review articles provides summary of current state of the research on a particular topic. Ideally, the writer searches for everythi ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen