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
Problem: (a) Briefly explain the ‘Hierarchical Database Model' using appropriate diagram. (b) List and briefly describe five potential benefits of the database approach comp
You want to implement following relationships when designing tables. How would you do it? a.) One-to-one b.) One-to-many c.) Many-to-many a.) One-to-One relationship -
Type of views : Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One
What is a PROJECT operation? The project operation is a unary operation that returns its argument relation with particular attributes left out. Projection is shown by pie (π).
What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users
Gyan Gurukul is a software company that provides software related solution. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan G
Describe the storage structure of indexed sequential files and their access method. Ans: Storage structure of Indexed Sequential files and their access: To achieve fast rand
Advantages of Data Distribution The primary benefit of distributed database systems is the ability to access and share data in a reliable and efficient manner.
What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac
Question: (a) What are the challenges in the development of Large Scale Distributed Real Systems? (b) What is backward engineering and forward engineering in a design packa
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