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 do you mean by consistency in rdbms?
An employee record has the following structure struct employee { int eno; char name[22]; float salary; char dept[10];}; (i) Calculate the record size R in bytes.
OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the
entity relationship diagram for online examination system
Home based assignment Consider an ORDER table with the following attributes: • Order Number (ONo),Customer Number (CNo),Customer Name (CNa),Item Number (INo),Unit Price (UP), Quant
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
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
Project Description: Critical Project for VMware Technical support. VMWare ESXi 5.1 support for upgradation and migration problem. Technical expert of Vmware needed. Sk
How are tables stored on Disk? We realise that every record of a table can have different amounts of data. This is due to in some records; some attribute values may be "zero".
What are the Overlapping elements Overlapping elements can be found by scanning all the elements in front of deleted element in priority list for the sheet and comparing them
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