Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
An orchestra database consists of the following relations: CONDUCTS (conductor, composition) REQUIRES (composition, Instrument) PLAYS (Player, Instrument) Give the relational calculus queries for the following:(i) List the compositions and the players. (ii) List the compositions which require the ‘violin' and the ‘congo'
Ans: (i) Tuple Calculus: {r[Composition] || p[Player] | r ∈ REQUIRES ∧ p ∈ PLAYS ∧ r[Instrument] = p[Instrument]} Domain Calculus: {c || p | ∃i1, i2 ( ∈ REQUIRES ∧ ∈ PLAYS ∧ i1 = i2)} (ii) Tuple Calculus: {r[Composition] | r ∈ REQUIRES ∧ ∃u (u ∈ REQUIRES ∧ r[Composition] = u[Composition] ∧ r[Instrument] = ‘violin' ∧ u[Instrument] = ‘congo')} Domain Calculus: {c | ∃i1, c2, i2 ( ∈ REQUIRES ∧ ∈ REQUIRES ∧ c1 = c ∧ i1 = ‘violin' ∧ i2 = ‘congo')}
∈ PLAYS ∧ i1 = i2)} (ii) Tuple Calculus: {r[Composition] | r ∈ REQUIRES ∧ ∃u (u ∈ REQUIRES ∧ r[Composition] = u[Composition] ∧ r[Instrument] = ‘violin' ∧ u[Instrument] = ‘congo')} Domain Calculus: {c | ∃i1, c2, i2 ( ∈ REQUIRES ∧ ∈ REQUIRES ∧ c1 = c ∧ i1 = ‘violin' ∧ i2 = ‘congo')}
What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the
Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin
Explain the Relational Completeness Codd described the term relational completeness to consider to a language that is complete with respect to first-order predicate calculus ex
Automated system for appointment with sms and call confirmation with service providers and user has to be initiate automatically. After selecting time and date to use service, s
Define and differentiate between ordered indexing and hashing. Ans: Ordered indexing: To gain fast random access to records in a file, we can make of an index structure. Every
Explain Candidate Key and Super Key A super key is a set of one or more than attributes that, taken collectively, permits us to identify uniquely a tuple in the relation. Wher
Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this info
What is foreign key? Foreign Key - Let there are two relations in tables R and S. Any candidate key of the relation R that is referred in the relation S is known as the forei
Problem 1. Write the SQL queries using Data Manipulation Language (DML) statements. Insert values into student table with field names using insert command Display the
A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd