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.
What is the difference between internal tables and extract datasets? The lines of an internal table always have the similar structure. By using extract datasets, you can ha
Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman
Write a short note on built in function in QBE? Built in function in QBE: QBE involves various built in functions like AVG, MAX,MIN,SUM and CNT. We must prefix these operator
How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with
Which method of access uses key transformation? A Hash method of access uses key transformation.
Describe Parameteric end users? Parametric end users might be given update access, but are commonly not permitted to change the structure of data.
write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.
QUESTION (a) Consider a car database consisting of car model, car make, car origin, Engine capacity, color, cost.
Farmer Bob, Farmer Jane and Farmer Jose run a cow farming co-op. For every cow they keep the cow’s name, age (or date of birth), breed and numbered plastic ear tag. The each of t
What is DBMS and what are functions of DBMS? DBMS consist of collection of integrated data and set of program to admission those data. The functions performed by a typical
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