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 conventions for displaying an ER schema as an ER diagram?
An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.
Mapping Cardinalities: Express the number of entities to that another entity can be related through a relationship. For binary relationship sets among entity sets A and B, the mapping cardinality must be one of:
1. 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. 2. One-to-many: An entity in A is related along with any number in B. An entity in B is related with at most one entity in A. 3. Many-to-one: An entity in A is related with at most one entity in B. An entity in B is associated with any number in A. 4. Many-to-many: Entities in A and B are related along with any number from each other.
The suitable mapping cardinality for a particular relationship set depends on the real world being modeled. Cardinality ratios for binary relationships are represented on ER diagram through displaying 1,M, N etc. on the diamonds.
Existence Dependencies: if the existence of entity X depends on the existence of entity Y, then X is said to be existence dependent on Y.
List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im
how to data store?
Determine the minimal set of functional dependencies for the following data. This table is part of the OHSU database of extracurricular activities and tracks the DMICE band's co
Define the terms i) DDL ii) DML DDL: Data base schema is specified by a set of definitions expressed by a special language known as a data def
Determine the rule that a value of a foreign key should appear as a value of some particular table is called a Ans: Referential constraint. The rule that a value of a fo
give some example real-life situations where DBMS are most suiitabe
A video rental company has several branches. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Ea
Index And Tree Structure Let us talk about the data structure that is used for creating indexes. Can we use Binary Search Tree (BST) as Indexes? Let us initial reconsider
List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti
Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every
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