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

Assignmentthis assignment consists of two sections a design

Assignment 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 assignment. Label each file nam ...

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

Relational databases with ms access1 create a table

Relational Databases with MS Access 1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run 2) Your code (for the button) will dynamically read the caption from the table and assign it t ...

Apriori analysis and cluster analysis-data analysis

ApriorI analysis and Cluster analysis-Data Analysis assignment CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" se ...

Your team is a consulting company that specializes in rapid

Your team is a consulting company that specializes in rapid application development. A client company wishes to improve their customer data and interactions records. You create a simple customer relationship system for t ...

This assignment consists of two 2 sections a design

This assignment consists of two (2) 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 assignment. Label each file name accor ...

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

Mis 204 hands-on activityaccess - forms and

MIS 204 Hands-On Activity: Access - Forms and Reports Introduction In this assignment you will learn how to create forms and reports to access and analyze your data. Forms are useful for data entry and navigation. Report ...

Relational database systems comp 1005objective this is an

Relational Database Systems (COMP 1005) Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scen ...

Projectfalcor supplies is a distributor of high tech

Project Falcor Supplies is a distributor of high tech teaching equipment. Its primary target customers are schools in the region who purchase the teaching equipment for classrooms and online use. The company's main compe ...

  • 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