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!
CREATE TABLE prodtrans
(
pno number (4)
ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5)
FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);
In the table so formed please reminder the referential constraint on the foreign key pno in prodtrans table to product table. Any product record if removed from the product table will trigger deletion of all the related records (ON DELETE CASCADE) in the prodtrans table.
Explain the terms primary key, candidate key, alternate key and secondary key. In the given table identify every key? STUDENT(SID,Regno, Name, City) Primary Key: The prim
What are domain constraints? A domain is a set of values that might be assigned to an attribute .all values that appear in a column of a relation must be taken from the similar
how draw er diagram
Though all the ABAP/4 Dictionary Structures that exists in the structure of the LDB, being described in Database Program, we are explaining the Dictionary Structures in the Report.
Explain the concept of a data model ? Data Model - Model is an abstraction procedure which hides irrelevant details although highlighting details relevant to the application
With the help of a suitable diagram gives module wise explanation of system architecture of DBMS.on..
explain equi-join using illustration
What are ways of finding out either an update is required or not for derived attributes? The ways to find out an update is required or, not are as: Explicit update
What is conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.
What is a guard condition? Explain it with a suitable example. The guard-condition is a Boolean expression written with respect to parameters of triggering event and attributes
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