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

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

Lab creating a database designthis assignment contains two

Lab: Creating a Database Design This assignment contains two Sections: Database Design Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Note: If you are us ...

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

Task - overview of business casealive amp boating aampb is

Task - Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the avai ...

Assignment database modeling and normalizationimagine that

Assignment: Database Modeling and Normalization Imagine that you work for a consulting firm that offers information technology and database services. Part of its core services is to optimize and offer streamline solution ...

Database design discusion 150 wordsnormalizationplease

Database Design Discusion (150 words) Normalization Please respond to BOTH of the following questions: Question A In your own words discuss the benefits of normalization. Question B Do you think we should normalize our d ...

Organizations want information organizations need

Organizations want information. Organizations need information. However, information must be in an organized format that supports the creation of business intelligence. Otherwise, according to Rebecca Wettemann, vice pre ...

Database in-class assignment normalizationfor the following

Database In-class Assignment Normalization For the following table, list the functional dependencies and create a database from the table that is in BCNF and 4NF. Movie Rating Showtime Theater The SpongeBob Movie PG 4:00 ...

Describe a database that might be used in nursing using

Describe a database that might be used in nursing. Using this data, explain the relationship between a field, a record, a table and a database. In addition, what are the advantages of managing database information in Acc ...

  • 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