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 steps for reduction of E-R model into relational model.
Ans:(a) Entity set in E-R model will be considered as table name in relational Model.
(b) Attributes of entity set in E-R diagram will be referred as fields or column name of table.
(c) Underline attributes of Attribute in E-R model will be considered as Primary key of the table.
The Second Normal Form (2NF) Definition: A relation is in 2NF if it is in 1NF and each non-key attribute is fully dependent on each candidate key of the relation. Some of th
discuss the purpose of the concurrency control?
Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1
What are the function of DBA?
Give the two reasons for allowing concurrency
Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim
Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher
Explain four causes for failures in data warehouse projects
What are called index-sequential files? The files that are ordered sequentially with a primary index on the search key are known as index-sequential files
Order by clause By using this rows can be sorted It is used in the last portion of select statement By default it gets ascending order DESC: is used
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