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 steps for reduction of E-R model into relational model.
Ans:(a) Entity set in E-R model will be considered as table name in relational Model.
(b) Attributes of entity set in E-R diagram will be referred as fields or column name of table.
(c) Underline attributes of Attribute in E-R model will be considered as Primary key of the table.
What are the various symbols used to draw an E-R diagram (any 3)?
What are called index-sequential files? The files that are ordered sequentially with a primary index on the search key are known as index-sequential files
Determine the advantage of object-orientation Finally, object-orientation has advantage of continuity throughout analysis, persistent representation and design implementation.
Forward Recovery (Redo): In this system the committed changes made by a transaction are reapplied to a previous copy of the database. In simpler
Spanned and unspanned organisation? Spanned and unspanned organization: If records are not permited to cross block boundaries then the organisation is called unspanned record
How to create a table from existing table? Create table as e.g, To create a new table ‘N_emp' with employee names and their identification numbers only from employee ta
Define the term Domain. For each n every attribute there is a set of permitted values known as the domain of that attribute.
Hi, Do you offer private tuition for DBMS?
prototype of a distributed information system for a national car part retail outlet chain.
Explain the terms primary key, candidate key, alternate key and secondary key. In the given table identify every key? STUDENT(SID,Regno, Name, City) Primary Key: The 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