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

Database analysis and designimplement the initial database

Database Analysis and Design Implement the initial database design for the Enterprise Resource Planning conceptual model described by the following requirements in your selected RDBMS. You need to create the Entity-Relat ...

Frontlines united states of secrets all Frontline's United States of Secrets, all

Frontline's United States of Secrets, all episodes: http://www.pbs.org/wgbh/frontline/film/united-states-of-secrets/ (Links to an external site.) Nova's Genome specials http://www.pbs.org/wgbh/nova/body/cracking-the-code ...

Homeworkgiven the relations below answer the following

HOMEWORK Given the relations below, answer the following queries using SQL. Note that the tables contain sample records only and do not represent all the possible records that could be stored in these tables. MEMB ERS ME ...

Exercise 1 - html and Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance

Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance from center (KM) Available 1 Les Jardins du Marais 3 Internet 74 rue Amelot, Paris, 75011 2 True 2 Golden Tulip Little Palace 4 Internet Gym Parking Res ...

Data information decision please respond to the

"Data Information Decision" Please respond to the following: • With the obvious pace of current technology development, data continues to grow daily. Imagine that you are a Database Administrator for a large organization ...

1 how are qbe tools and sql similar2 how are they

1. How are QBE tools and SQL similar? 2. How are they different? 3. What is a data warehouse? 4. How does it differ from a database?

The use of an access database has become very common over

The use of an Access database has become very common over the last 10 years. Access is the preferred desktop database because server databases such as structured query language (SQL) and others are too complex and are be ...

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

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

Data warehouses and data martswrite a one- to two-page

Data Warehouses and Data Marts Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts t ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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