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

Replacement china incproject descriptionyou work as an

Replacement China, Inc. Project Description: You work as an associate database manager at Replacement China, Inc. This firm specializes in finding difficult-to-replace, no-longer manufactured china, crystal, silver, and ...

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

Assignment business rules and data modelssuppose a local

Assignment: Business Rules and Data Models Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and cour ...

Database designfrom textbook fundamentals of database

Database Design From Textbook: Fundamentals of Database Management Systems 2nd Edition. 1. Convert the Video Centers of Europe, Ltd., entity-relationship diagram in Exercise 2.2 into a well structured relational database ...

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

Discussionyou have been asked to help a critical

Discussion You have been asked to help a critical infrastructure company in analyzing the privacy and security of a SCADA system. Conduct research on the topic and answer the following: 1. How would you describe general ...

Database systems assignment - student enrolment database a

Database Systems Assignment - Student Enrolment Database A. Task Description 1. Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, de ...

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

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

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

  • 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