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

Taskoverview of business casealive amp boating aampb is a

Task Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the availa ...

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

Question - databasesuse database software such as microsoft

Question - Databases Use database software such as Microsoft Access or LibreOffice Base to perform the following actions. (Refer to Workshops 9 & 10 for help.) A. Create a new database. Add tables based on the design of ...

Database normalizationnormalize the below orders table to

Database Normalization Normalize the below Orders table to 3NF. Make sure to identify all the entities and their attributes, especially if you make any new items (such as entity or attributes). The following is a list of ...

Tasks objectives1 manage client-server connections using

Tasks Objectives: 1. Manage client-server connections using RDBMS Net Services 2. Evaluate requirements and select appropriate parameters to ensure effective storage management in a database system 3. Manage Redo log inf ...

Database design discusion post and assignmentdiscusion post

Database Design Discusion Post and Assignment Discusion Post: Data as a Corporate Resource and Foreign Keys Please respond to BOTH of the following questions: Question A Discuss how data can be a corporate resource and d ...

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

Describe a database that might be used in nursing using

Describe a database that might be used in nursing. Using this data, explain the relationship between a field, a record, a table and a database. In addition, what are the advantages of managing database information in Acc ...

Listed the five important software components of a dbms the

Listed the five important software components of a DBMS: the DBMS engine, the data definition, data manipulation, application generation, and data administration subsystems. Which of those are most and least important to ...

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

  • 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