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!
Define the terms 1) physical schema 2) logical schema.
Physical schema: The physical schema explains the database design at the physical level, which is the lowest level of abstraction describing how the data are actually stored.
Logical schema: The logical schema explains the database design at the logical level, which explains what data are keeps in the database and what relationship exists between the data.
In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.
Give the two reasons for allowing concurrency
Explain Stand Alone Query Language in details? Stand alone Query Language - The query language that can be used interactively is known as stand alone query language. It does no
For every multivalued attribute 'A', we make a new relation R that contains an attribute corresponding to plus the primary key attribute k of the relation that shows the entity typ
Partial Key : It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator. Altern
Consider an information system designed for an online company which provides IT products and services These include desktops, laptops, networking products, IT books, parts, and
can you please explain with the help of suitable example the difference between conflict equivalence and conflict serializability?
Consider the relations described below: PHYSICIAN (regno, name, telno, city) PATIENT (pname, street, city) VISIT (pname, regno, date_of_visit, fee) Where the regno and pname ide
Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th
Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.
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