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.
Creation of Indexes Automatically: When a primary key or Unique constraint is show in a table definition then a unique index is formed automatically. Manually: User can
which component of DBMS can be embedded in a program? The data manipulation language (DML) is a component which is embedded in a program.
Question: Using the data model express the following queries in SQL. (a) Create the Table named "Cinema" and make the cinema_code to be the primary key of the relation and
Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera
What are the comparison operator in SQL? Comparison operator in SQL are =, LIKE and BETWEEN
We face problem of stock Opening balance and closing balance in Minus
Determine Which is not a consequence of concurrent operations? Ans: Update anomaly.
Define deadlock avoidance. An alternative method for avoiding deadlocks is to needs additional information about how resources are to be requested. Each request requires the s
Describe the definition of a transaction in SQL Ans: The SQL transaction starts implicitly. Transactions are finished by either Commit work that commits the transaction and st
Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External
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