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!
Explain the integrity constraints: Not Null, Unique, Primary Key with an example each. Is the combination 'Not Null, Primary Key' a valid combination. Justify.
Not Null - Should hold valid values and cannot be NULL.
Unique - An attribute or a combination of two or more attributes must have a unique value in each row. The unique key can have NULL values.
Primary Key - It is similar as unique key but cannot have NULL values. A table can have at most one primary key in it.
For example:
STUDENT
Roll No
Name
City
Mobile
17
Ankit Vats
Delhi
9891663808
16
Vivek rajput
Meerut
9891468487
6
Vanita
Punjab
NULL
75
Bhavya
delhi
9810618396
Roll No is a primary key.
Name is defined with NOT NULL, means each student must have a name.
'Not Null, Primary Key' is a valid combination. Primary key constraint already includes
'Not Null' constraint in it but we can also add 'Not Null' constraint with it. The use of
'Not Null' with 'Primary Key' will not have any effect. It is same as if we are using just 'Primary Key'.
Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following
What functions does a data dictionary perform? In a (DBMS)data management system, the principal functions performed by the data dictionary are Management of data defini
write program
Write short notes on tuple relational calculus. The tuple relational calculation is anon procedural query language. It defines the desired information without giving a particul
Objectives After reading this unit you should be able to: Explain storage of databases on hard disks; Discuss the execution of various file Organisation techniques;
What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.
Define the notation for classes and atrributes The notation for class, attribute, and operations are shown below: Figure: Class with attributes and operations A
We require an advanced system for a Sports Centre, you are concerned only with representing the data discussed below about bookings and members. (The complete system may contain ot
Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas
What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers
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