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.
What is Collation Collation is a kind of sort order. There are majorly 3 types of sort orders, namely: i.) Dictionary case insensitive ii.)Dictionary - case sensitive
Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas
For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti
Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are
What is an Operand? The data on which the operation is to be performed is known as an Operand
Question 1: a) What is the difference between a non-impact and impact printer? b) Which type of printer is generally used in a supermarket to print your receipt? Describe
Two Phase Locking (2PL) The two-phase locking protocol having of two phases: Phase 1 : The lock acquisition phase : If a transaction T needs to read an object, it wants to
What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing ii) IDs are completely independent of the changes in data v
using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat
Differentiate between strict two-phase and rigorous two-phase with conversion protocol Ans: Strict two-phase locking holds all its exclusive that is write locks until commit t
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