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!
Consistency error: These errors happen due to the inconsistent state of database caused may be due to wrong implementation of commands or in case of a transaction abort. To overcome these errors the database system should contain routines that check for the consistency of data entered in the database.
Given the subsequent relations: vehicle (reg_no, make, colour) Person (eno, name, address) Owner (eno, reg_no) Write expressions
Give the forms of triggers? The triggering event can be insert or delete. For updated the trigger can state columns. The referencing old row as clause The referencing
What are data models? Explain it detail? Entity relationship model Rectangles Ellipse Diamonds Lines Relational model Relational model use a collection
What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the
why data in an RDMS need to be normalised
explain in details about one to one binary relationship
Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin
Physical Records These are the records that are stored in the secondary storage devices. For the database relation, physical records are the group of fields kept in adjacent me
Which types of data supported by MySQL for Time and Date formats? MySQL supports a number of time and date column formats: Some of them are 1) DATE 2) DATETIME 3) TIM
Use of partial data by applications : In common, applications work with views rather than whole relations. Thus, it may be more appropriate to work with subsets of relations rather
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