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

Relational databases theory and practice assignmentanswer

Relational databases: theory and practice Assignment ANSWER ALL QUESTIONS Question 1 - Use the block notes to answer the following questions: i. Explain what is meant by the process of denormalization and how it is done. ...

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

Assignment1write a query that retrieves studentlastname

Assignment 1. Write a query that retrieves student.last_name, student.first_name and total number of enrollments from the student and enrollment tables. Your query should also include students that do not have any enroll ...

Use sql management studio to create a database called

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data to the database. Use the appropriate field types ...

Data warehouse1 review the submission hokie resort

Data Warehouse 1. Review the submission Hokie Resort situation description to understand the problem domain(see Business Situation Description below) 2. Write the three most important questions that management must answe ...

Database design assignmentpart 1customer resource

Database Design Assignment Part 1 Customer Resource Management Database You have been tasked to develop a set of tables for a customer resource management database. You are required to store the following information in ...

Case problem-global site gps - kevin hodge is a production

Case Problem- Global Site GPS - Kevin Hodge is a production assistant at Global Site GPS, a leading manufacturer of GPS devices located in Crestwood, Missouri. One of Kevin's jobs is to monitor output at the company's fi ...

Hospital database determining keysdevelop a microsoft

Hospital Database: Determining Keys Develop a Microsoft Access database based upon the following business scenario. Be sure to include tables, fields, keys, relationships, and test data in your database. Your final submi ...

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

Create a data definition class to model one product sold at

Create a data definition class to model one product sold at a bakery. The product will have a description, cost, and quantity in stock. Instance methods include: accessors for each instance variable, non-validating mutat ...

  • 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