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 types of integrity constraints in which must be checked for the update operations - Insert and Delete. Give examples.
Insert operation can violet any of the subsequent four constraints:
1) Domain constraints could be violated if given attribute value does not appear within corresponding domain. 2) Key constraints could be violated if given attribute value does not appear within corresponding domain. 3) Entity integrity can be violated if the primary key of the latest tuple t is NULL. 4) Referential integrity can be violated if value of any foreign key in t refers to a tuple in which does not exist in referenced relation.
Delete operation can violate only referential integrity constraints, if the tuple being deleted is referenced through the foreign keys from other tuples within the database.
Explain the EXISTS and UNIQUE functions of SQL. Give an example for each? EXISTS: The EXISTS function takes one parameter that is a SQL statement. If any records exist which
What are the DBMS languages? Briefly explain? Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language
Describe the two types of methods for retrieving rows in Python? Fetchone()- Returns the next row as a sequence Fetch all()- Returns the entire result set like a strin
Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas
Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO
brief history,definition,current trends and future trends if any of data fragmentation
What is foreign key? A relation schema r1 derived from an ER schema may contain among its attributes the primary key of another relation schema r2.this attribute is known as a
Attributes attached to an entity can be of various types. Simple The attribute that cannot be further separated into smaller parts and shows the basic meaning is known as a
What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys
folding method and mid square method using visual basic
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