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!
Consider the following relational schema: Doctor(DName,Reg_no) Patient(Pname, Disease) Assigned_To (Pname,Dname) Give expression in both Tuple calculus and Domain calculus for every of the queries:(i) Get the names of patients who are assigned to more than one doctor. (ii) Get the names of doctors who are treating patients with ‘Polio'.
Ans: (i)Tuple Calculus: {p[PName] | p ∈ PATIENT ∧ ∃a1, a2 (a1 ∈ ASSIGNED_TO ∧ a2 ∈ ASSIGNED_TO ∧p[PName] = a1[PName] ∧ a1[PName] = a2[PName] ∧ a1[DName] ≠ a2[DName])} Domain Calculus:{p | ∃p1, d1, p2, d2 (
∈ PATIENT ∧ ∈ ASSIGNED_TO ∧ ∈ASSIGNED_TO ∧ p1 = p2 ∧ d1 ≠ d2)} (ii)Tuple Calculus: {u[Dname] | u ∈ ASSIGNED_TO ∧ ∃t (t ∈ PATIENT ∧ t[Disease] = ‘Polio' ∧t[PName] = u[PName])} Domain Calculus: {d | ∃p1, p2, s2 ( ∈ ASSIGNED_TO ∧ ∈ PATIENT∧ p1 = p2 ∧ s2 = ‘Polio')}
explain in details about one to one binary relationship
Write short notes on Schema diagram. A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema diagram. Every relation appea
List any two significant differences between a file processing system and a DBMS. File Processing System vs. DBMS Data Independence - Data independence is the capacity t
Normal 0 false false false EN-IN X-NONE X-NONE
Project Description: This is going to be a School portal to handle each activities in school such as, School fees payment, online registration and every other payment, course re
Physical Database Design Issues The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.
Hi is anyone well versed in accounting information systems available now to help me work through an important assignment due tomorrow at noon?
A table joined with itself is called ? A table joined with itself is known as self join table. Normal 0 false false false EN-IN X-NONE X-NONE
explain five responsibilities of DBA?
We have a buildup of payments that need to be processed. You will need:- To prepare customer account on our site Process payment (you must have working Paypal account to d
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd