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

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 ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

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 ...

Assignment business rules for sam symthes

Assignment: Business Rules for Sam Symthe's Database Overview Sam Smyth is an expert puppy trainer. His specialty is training troubled puppies to behave for their owners. The name of his business is Sam Smythe's Kennel f ...

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 ...

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

Relational database systems comp 1005objective this is an

Relational Database Systems (COMP 1005) Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scen ...

1 what is the most popular database model2 how are primary

1. What is the most popular database model? 2. How are primary and foreign keys different? 3. What are the five important software components of a database management system? 4 What are the four major types of data-minin ...

Assignmentconsider the employee database with the following

Assignment Consider the employee database with the following list of tables. Please create these tables with appropriate primary keys & foreign keys. The list of tables is: Company(cid, company_name, city, state) /* city ...

Here is two assignment one is only summery of project from

Here is two assignment one is only summery of project from first assignment, in powerpoint. pleasedont copy and paste, it will be verified by software for plagiarism. please cite all sources by APA format. due date is 26 ...

  • 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