Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1)a) With essential exs, define the following:

i) Super Key

ii) Primary Key

b) How the EER diagram can be reduced to relations? Describe.

c) Consider the following relational schema Hotel(hotelNo, hotelName, city) Room(roomNo, hotelNo, type, price) Booking(BookingID, hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest(guestNo, guestName, guestAddress) prepare the following queries in SQL.

i) prepare the names of hotels located in Bangalore.

ii) List the no. of rooms currently available in each hotel.

iii) Find the roomNo. that is booked for longest period of time(need not be contiguous) by one or more customers in Hotel H10.

problem 2)a) What is Nesting? Demonstrate the usage of collect function and sub queries in nesting.

b) Briefly describe the various approaches proposed to make the objects persistent.

c) Consider a database schema with a relation Dept whose attributes are as shown below, with types specified for multivalued attributes.

Dept = (Dname, MgrID, EmployeeSet multiset(Employee), ProjectSet multiset(Project)) Employee = (EmpID, Ename, BirthDate, Salary, SkillSet multiset(Skill)) Project = (ProjID, PName, StartDate, Budget) Skill = (Type, Grade)

i) Define the above schema in SQL:2003, with appropriate types for each attribute

ii) Using the above schema, prepare the following queries in SQL:2003.

iii)Determine the names of all employees who have born after 1-1- 1970.

iv) List all the skill types possessed by the employees.

v) List all the employees who have ‘A’ grade in any of the skills.

problem 3)a) Briefly describe the following in the context of Data Servers:

i) Locking

ii) Data Caching

iii) Lock Caching

b) Describe the different partitioning techniques used for I/O parallelism. Which of these techniques are appropriate for point queries? Why?

c) describe fragment and replicate, and asymmetric fragment and replicate join methods for non-equijoin conditions. 

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

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

Create a database to keep inventory of something you own

Create a database to keep inventory of something you own, such as books, CDs, movies, collectibles, etc. You can make these up if you want. (You could use this in real life to keep track of what other people have borrowe ...

Discussionnormalization and redundancy please respond to

Discussion "Normalization and Redundancy" Please respond to the following: • Suggest one of the problems that normalization seeks to solve within a database. Describe one example of your suggested problem, and explain th ...

Suppose that you are the database developer for a local

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 upcoming training s ...

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

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

Assignment business intelligence and data

Assignment: Business Intelligence and Data Warehouses Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a man ...

Option simulation preparation paperby the end of module 2

Option : Simulation Preparation Paper By the end of Module 2, you will have received the URL, team name (also known as logon ID), and password for the Littlefield Simulation site from your instructor. This week, you must ...

Project database and programming designthis assignment

Project: Database and Programming Design This assignment consists of two sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this a ...

At this point you decide to implement a hash structure for

At this point, you decide to implement a Hash structure for the contributor data to prepare for searches. You will read the contributor information from a file provided; it is a comma delimited (CSV) file. As each record ...

  • 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