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!
Discuss the differences among the candidate keys and the primary key of a relation. Give instance to describe your answer?
A candidate key is one that can be used as primary key which not null and unique constraint both is holding true. In short all primary keys are definitely candidate keys. That is one of the candidate keys is selected as primary key.
Discuss The difference between drop table R and delete from R. DROP TABLE command deletes all the records with the table definition. This command will automatically committed
What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.
First Normal Form and second normal form First Normal Form (1NF) A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combinat
Consistency: This property makes sure that a complete transaction implementation takes a database from one consistent state to another consistent state. If the transaction fails e
external view of DBMS in healthcare department?
What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row
explain in details about one to one binary relationship
Describe the functions and features of foreign key? Foreign Key : The primary key of one file or table that is implanted in another file or table to implement the relationships
What are the ways of obtaining the connection parameters? Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters
What is conceptual model ? A conceptual model is a independent of both hardware and software.
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