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

Assignment database environment proposalas one of the

Assignment: Database Environment Proposal As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standa ...

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

How up-to-date should data warehouse information

HOW UP-TO-DATE SHOULD DATA WAREHOUSE INFORMATION BE? Information timeliness is a must in a data warehouse-old and obsolete information leads to poor decision making. Below is a list of decision-making processes that peop ...

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

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

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

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

Problem iyoull be happy to know that we made a strong case

Problem I "You'll be happy to know that we made a strong case to manage¬ment that we should hire a new systems analyst to specialize in ecommerce development," says Al Falfa, a systems analyst for the multi-outlet intern ...

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

Assignmentconsider the employee database with the following

Assignment Consider the employee database with the following list of tables. Please create these tables with appropriate primary keys & foreign keys. The list of tables is: Company(cid, company_name, city, state) /* city ...

  • 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