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!
Describes the several relationship constraints through giving suitable example?
Constraints on relationships: There are two kinds of constraints on relationships.
1) Mapping cardinalities or cardinality ratios express the number of entities to that another entity can be associated through a relationship set. For a binary relationship set among entities A and B. The mapping cardinality may be any one of the subsequent:
a) One to One: An entity in A is related along with at most one entity in B and an entity in B is related with at most one entity in A.b) One to Many: An entity in A can be related with any number in B but an entity in B is associated with at most one in A.c) Many to one: An entity in A is related with at most one in B but an entity in B is associated with any number in A.d) Many to Many: An entity in A and B can be associated along with any number of entities in the other entity set.
2) Participation constraints: The participation of an entity set E in a relationship set R is said to be total if every entity in E participates within at least one relationship in R. If only a few entities in E participation of entity set E in relationship R is said to be partial.
Explain the relevance of Data Dictionary in a Database System? Data dictionary is a database in its own right residing on the disk that consist of Meta data which is = Data abo
What is a view? Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary. Ans: View is a virtual table that does not consist
what does glory be mean
Describe the tools that are available for managing MySQL Server. Given below are the tools to manage MySQL server: mysqld - MySQL server daemon. This is used to begain t
Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera
Project Description: This is a Customer Management project. Customer data is presented in a text file. The program can load this text data into its database columns. The data ma
Mention the various user privileges All privileges directly granted to the user or role. All privileges granted to roles that have been granted to the user or role.
Data slice explanation
give me a diagram about physical or internal level
How can one distinguish among different kinds of parameters? Input parameters are used to pass data to subroutines. Output parameters are used to pass data from subrout
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