User Account

All Pages

Give an example of a view on emp that would be impossible to

Assignment Help Database Management System
Reference no: EM13509179

Brie?y answer the following questions based on this schema:

Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pct time: integer) Dept(did: integer, budget: real, managerid: integer)

1. Suppose you have a view SeniorEmp de?ned as follows:

CREATE VIEW SeniorEmp (sname, sage, salary) AS SELECT E.ename, E.age, E.salary

FROM      Emp E WHERE E.age > 50

Explain what the system will do to process the following query: 

SELECT S.sname FROM      SeniorEmp S

WHERE S.salary > 100,000

2. Give an example of a view on Emp that could be automatically updated by up-dating Emp.

3. Give an example of a view on Emp that would be impossible to update (auto-matically) and explain why your example presents the update problem that it does.

Reference no: EM13509179

Questions Cloud

What is the tangential acceleration of the discus thrower : A discus thrower (with arm length of 1.2 m) starts from rest and begins to rotate counterclockwise with an angular acceleration of 1.5rad/s2. What is the tangential acceleration of the discus thrower at this point
Prepare the company planning budget : Prepare a flexible budget performance report for the company using the actual income statement information shown below.
Estimate the constant angular acceleration of the centrifuge : A centrifuge in a medical laboratory rotates at an angular speed of 3750 rpm (revolutions per minute). Find the constant angular acceleration of the centrifuge
Compute the materials quantity variance and materials price : Harmon Household, Inc. manufactures a number of consumer items for general household use. During the recent month, the company manufactured 4,000 chopping blocks using 11,000 feet of hardwood.
Give an example of a view on emp that would be impossible to : Give an example of a view on Emp that would be impossible to update (auto- atically) and explain why your example presents theupdate problem that it does.
Compute production cost per unit under variable costing : Determine the cost of ending inventory using absorption costing.
What is the value of the lorentz gamma factor : A muon is formed high in the Earth's atmosphere and travels at a speed 0.9 c with respect to the Earth. What is the value of the Lorentz gamma factor associated with the muon's motion
Determine the accounts receivable as of that date : Assume that the company will prepare a budgeted balance sheet as of September 30. Determine the accounts receivable as of that date.
What is the velocity of the first ball as it strikes ground : Two students are on a balcony 21.4 m above the street. One student throws a ball vertically downward at 13.3 m/s; at the same instant,  What is the velocity of the first ball as it strikes the ground

Reviews

Write a Review

Database Management System Questions & Answers

  Dsign document 1write a four to sixnbsp page design

this assignment consists of two sections a design document and a revised project plan. you must submit both sections

  Explain it project to coordinate and maintain records

The system should support notifications to management personnel whenever their direct reports have submitted documentation. The system should also notify employees if their deadline to complete professional-development requirements is approaching ..

  Implementation of virtual private databases

SQL implements VPD using the VIEW object while Oracle10g provides specific functions for row-level security and fine-grained access.

  Indicate change to make original premiere products database

Indicate the changes (using the shorthand representation) that you would need to make to the original premiere products database desing to support the following requirements.

  Number of employees at the new book sales corporation

To identify the number of employees at the New Book Sales Corporation, you view the records in the Sales Department table.

  Ideal choice for relational database design

The Entity-Relationship Diagram is widely used in the design of relational databases. Why do you think this is so - what is it about this model that makes it the ideal choice for relational database design?

  Explain the life cycle of an information systems

Imagine that you run a photography printing store. Your employees have been using punch cards for time entry since you started the business.

  List all the foreign key constraints among these relations

Give an example of a (plausible) constraint involving one or more of these relations that is not a primary key or foreign key constraint.

  Physical schema created for a database

At this point in the design process, you would have a detailed physical schema created for a database. How would you approach converting your schema into a database, complete with sample data? Explain your approach in two to three paragraphs.

  Draw a context diagram and a level-0 dfd

develop the report having each task clearly numbered togetherwith your answer. You are also expected to write an introduction and conclusion for this report.In performing the following tasks, you have to strictly follow all diagramming rules used ..

  What are the candidate keys of r

Suppose you have a relation schema about teaching classes that has the following attributes: Class, Instructor, Time and Room.

  Wallsherpool sixth - theatre company

A report that shows the characters that still need actors for the current performance and storing the student details if all requirements are met, providing a suitable message for Vicky

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd