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 concepts of relational data model?
Relational Data Model - The relational model was first introduced through Prof. E.F. Codd of the IBM Research in the year 1970 and attracted immediate attention because of its simplicity and mathematical foundation. The model uses the concept of a mathematical relation (such as a table of values) as its primary building block, and has its theoretical basis within set theory and first-order predicate logic. The relational model represents the database as a collection of relations. The relational model such as all other models consists of three basic elements:
List any eight applications of DBMS. a) Universities b) Airlines c) Banking d) Credit card transactions e) Tele communication f) Sales g)Finance h) Manufac
Which method of access uses key transformation? A Hash method of access uses key transformation.
Increases efficiency : Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, there
How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct
Which of the operations constitute a basic set of operations for manipulating relational data? Relational algebra operations constitute a basic set of operations for manipulati
Explain three main attributes of data.
Explain the differences between structured data and unstructured data. Structured data are facts concerning objects and events. The most significant structured data are numeric
Consider a relation s over the attributes A and B with the following characteristics: 5,000 tuples with 10 tuples per page A 2-level B+ tree index on attribute
State the meaning of Object Representation The term object representation means "to represent object with the help of objects model symbols". Implementing objects is too simp
What is theta join explain? Theta Join - The theta join operation is an extension to the natural-join operation which permits us to merge selection and a Cartesian
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