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!
Many-to-many: Entities in A and B are related with any number of entities from each other.
Example:
Taught_by Relationship among course and faculty.
One faculty member can be assigned to teach a lot of courses and one course may be taught by a lot of faculty members.
Relationship among book and author.
One author can explained a lot of books and one book can be written by more than one authors.
More about Relationships and Entities
What is a view in SQL? When can views be updated? A view is a virtual table which consists of columns from one or more tables. Through it is same to a table; it is stored in
Create centralized relational database using bottom up method. (a) Recognize a single un-normalized relation for the above scenario. (b) Recognize the primary key for
WHAT IS SQL
Define blocks? The database system resides eternally on non-volatile storage, and is into fixed-length storage units known as blocks.
What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.
Determine the language that needs a user to specify the data to be retrieved with no specifying exactly how to get it is Ans: Non-Procedural DML
Express types of information available in MySQL? Information as regards the result of queries: This includes number of records affected by any SELECT or UPDATE or DELETE st
What is a candidate key? Minimal super keys are known as candidate keys.
How many levels can be viewed in Architecture of the database ? Architecture of the database can be viewed as three levels.
A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....
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