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!
Describe the primary key functions?
Primary Key : The primary key is an attribute or a set of attributes in which uniquely identify a specific example of an entity. Every entity in the data model must have a primary key whose values uniquely recognize instances of the entity.
To qualify as a primary key for an entity, an attribute must have the subsequent properties: * It must have a non-null value for each instance of the entity. * The value must be unique for each instance of an entity * The values must not change or become null during the life of each entity instance.
Describe Object Relational model ? Object Relational Model - This model combines the characteristics of both relational model and object oriented model. It extends the tradit
difference between internal schema and external schema in DBMS
The result of the UNION operation between R1 and R2 is a relation that includes? The result of the operation between R1 and R2 includes all the tuples of R1 and R2 which have c
In object oriented design, which steps must designer take to adjust inheritance? To readjust inheritance following steps should be taken: i) Rearrange and adjust the classe
Special comparison operator used in where Clause a. between. ...and...It gives range among two values (inclusive) Example: SELECT ENAME, SAL FROM EMP WHERE SAL BETWE
What is the full form of DDL? DDL is stand for Data Definition Language.
The data of a view is not physically stored, but derived from one or more tables. True the data of a view is not physically stored
What is DML (Data Manipulation Language)? This language that enable user to access or manipulate data as organised by appropriate data model. Procedural DML or Low level: DM
Mention the several levels in security measures. A) Database system B) Operating system C) Network D) Physical Human
For problems 1-4, give all candidate keys for the tables with FDs specified. Composite candidate keys must be put in parentheses, and candidate keys must be separated with commas
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