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
aggregation
Give an example of Operations from the functions of a bank. For creation of a saving account, you can write: bank::: create -savings-account (customer)->account. For oper
explain five responsibilities of DBA?
Describe log based recovery The most usably structure for recording data base modification is the LOG the log is a sequence of log records recording all the update activities i
What was the method in which records are physically stored in a specified order according to a key field in each record ? A method in which records are physically stored within
Which is a legal expression in SQL? SELECT NAME FROM EMPLOYEE is a legal expression in SQL.
Explain in details about the f unctions of DBA ?
What is meant by software and hardware RAID systems? RAID can be executed with no change at the hardware level, using only software modification. Such RAID implementations are
What is the role of a database administrator?
find the name of supplier who supply some red part
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd