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 Candidate Key and Super Key
A super key is a set of one or more than attributes that, taken collectively, permits us to identify uniquely a tuple in the relation. Whereas a candidate key is a minimal superkey that can be used to uniquely identify a tuple in the relation. In superkey, there may a few extra attributes.
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
Before we talk about the relational model in more detail, let us first define some very basic terms used in this model. Tuple Every row in a table shows a record and is cal
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
Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b
Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))
Un-Normalized Form (UNF) If a table having non-atomic values at every row, it is said to be in UNF. An atomic value is something that cannot be further decomposed. A non-atomic
In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.
What is an ER diagram? Why is it used in Database management system (DBMS)?
What is the difference between link and reference? The fundamental difference between links and references is that links are symmetrical on the other hand references refer only
What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim
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