Define views in relational algebra, Database Management System

Assignment Help:

Views in relational algebra:

1. Basic expression contains either

a) A relation in the database.

b) A constant relation.

2. General expressions are madde out of smaller sub expressions using

a) σ_p(E₁) select (p a predicate)

b) ∏s(E₁) project (s a list of attributes)

c) P_x(E₁)rename (x a relation name)

d) E₁∪E₂ union

e) E₁- E₂ set difference

f) E_1x x E₂ cartesian product

Related Discussions:- Define views in relational algebra

What do you mean by atomicity and aggregation, What do you mean by atomicit...

What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

MS Access 2010 - Form Updates Table, Hi there, Have an issue with my Databa...

Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect

Define forms based interfaces, Define Forms Based Interfaces? Forms-Bas...

Define Forms Based Interfaces? Forms-Based Interfaces - A forms-based interface display a form to each user. Forms are commonly designed and programmed for naive users and inte

Explain the need for the bcnf normal form, Surgeons identified by doctor ID...

Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on

Need for multiple access paths, Need for Multiple Access Paths In pract...

Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav

What was the method in which records are physically stored, What was the me...

What was the method in which records are physically stored in a specified order according to a key field in each record ? A method in which records are physically stored within

Find a 3nf decomposition , Find a 3NF decomposition of the following relati...

Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following

Project, write a database program for concurrency transaction in a bank

write a database program for concurrency transaction in a bank

Explain disadvantages of a dbms, Question : (a) Database Management Sy...

Question : (a) Database Management Systems (DBMS) is the foundation of business intelligence. Explain the following concepts related to DBMS: (i) Entity Relationship Diagr

Er diagram with explanation and their conversion in to table, example of ba...

example of bank

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages