Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1)a) What is data abstraction? Describe the levels of data abstraction.

(b) Consider the following relational database and give an expression in the relational algebra for each of the following queries:
employee( person_name, street, city)
works (person_name, company_name, salary)
company (company_name, city)
manages (person_name, manager_name)

(i) Find the company with the most employees.

(ii) find the company with smallest payroll.

(iii) Find the names and cities of residence of all employees who work for First bank corporation.

(iv) Give all managers in the database a 10 percent salary raise, unless the salary would be greater than Rs. 100,000. In such cases give only a 3 percent raise.

(c) Describe the different outer join operations with ex.

problem 2)(a) Describe the test for empty relations in nested queries.

(b) Use following schema and prepare the queries:

Employee(Fname, Initial, Lname, ENo, DOB, Addr, Sex, Salary, SENo, DNo)
Department(DNmae, DNo, MgrENo, MgrStDt,)
Dept_Location(DNo, DLocation)
Project(PName, PNo, PLocation, DNo)
Work_on(ENo, PNo, Hours)
Dependent(ENo, Dep_Name, Sex, DOB, Rel)

i) Give all employees in the research dept a 10% salary raise.

ii) Retrieve the name of employees who have no dependents (use exists/not exists).

iii) For each project retrieve the project number, project name, number of employees from department 5 who work on the project.

iv) Retrieve a list of employees and the projects they are working on, order by dept and within dept alphabetically by last name and first name.

(c) Describe the update of a view.

(d) Describe view serializability with ex.

problem 3)(a) What are attributes? Describe various types of attributes with ex. How they are represented in an ERD.

(b) Consider the University database application with following details:

• An University has many departments.

• Each department has multiple instructors; one among them is head of department.

• An instructor belongs to only one department.

• Each department offers multiple courses, each of which is taught by a single instructor.

• A student may enroll for many courses offered by different departments.

Draw the ERD for the above by identifying entities, relationships, attributes and cardinality.

(c) Describe the concept of recoverable and cascade less schedules.

DBMS, Programming

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

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

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

Assignment advanced relational databaseproject- advance

Assignment: Advanced Relational Database PROJECT- Advance SQL Overview: Using the knowledge garnered thus far, please solve all of the below problems. Please run the attached SQL script file at the SQL*PLUS prompt. This ...

Homeworkunlimited pickers is a group of workers who have

Homework Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from loca ...

Virtualization fundamentalsunit 3 research projectwrite an

Virtualization Fundamentals Unit 3 Research Project Write an overview of *any two* of the following topics. Each overview should be between one half and one full page long. You should use a minimum of two sources for eac ...

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

Moving average forecasting modelsmoving average forecasting

Moving Average Forecasting Models Moving average forecasting models are powerful tools that help managers in making educated forecasting decisions. A moving average is mainly used to forecast short historical range data. ...

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

Computer sciencein reference to your database design

Computer Science In reference to your Database Design Proposal: Proposal Outline, provide a narrative analysis of the customer and user needs by defining the customers and users as well as describing their individual nee ...

1 what is the most popular database model2 how are primary

1. What is the most popular database model? 2. How are primary and foreign keys different? 3. What are the five important software components of a database management system? 4 What are the four major types of data-minin ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen