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!
Discuss along with examples about several types of attributes present in the ER model?
Types of Attributes are:• SIMPLE attributes are attributes which are drawn from the atomic value domains E.g. Name = {John} ; Age = {23}• COMPOSITE attributes: Attributes that consist of a hierarchy of attributes E.g. Address may consists of "Number", "Street" and "Suburb" → Address = {59 + ‘Meek Street' + ‘Kingsford'}• SINGLE VALUED attributes: Attributes which have only one value for each entity E.g. Name, Age for EMPLOYEE• MULTIVALUED attributes: Attributes that have a set of values for each entity E.g. Degrees of a person: ‘ BSc' , ‘MIT', ‘PhD'• DERIVED attributes: Attributes Contain values which are computed from other attributes Eg. Age can be derived from attribute DateOfBirth. In this situation, DateOfBirth might be known as Stored Attribute
What is object containment? References among objects can be used to model dissimilar real-world concepts.
What are the different kinds of database end users? Discuss the major activities of each? End-Users - End-users are the people whose jobs need access to the database for que
Entity types that do not have any key attribute, and therefore cannot be identified independently, are known as weak entity types. A weak entity can be recognized uniquely only by
Define the categories of SQL Statements? 1) Statements that don't return a result set. This statement class includes INSERT, DELETE, and UPDATE. 2)Statements that return
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 ,.....
Database design Database tables will be created for you on the Technology web server. The schema will be as follows. Please note that this is a simplified database structure, d
Explain the Dynamic Hashing Techniques There are two methods in it: extendible hashing - stores an access structure in addition to the file, and therefore is somewhat identica
Northwind Pty Ltd sells a variety of food products throughout the world. They want to use the reporting features of SAP''s Business Information Warehouse to better understand thei
Hello.I have database access assignment which consist of creation Form, Subform, Calculation, Macros
Can a domain, assigned to a data element be changed? Yes. We can do so by just overwriting the entry in the field domain.
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