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!
What are the different approaches for database design?
There are two basic approaches for database design which are as follows:
Attribute driven: It compiles a list of attributes relevant to application, and normalizes the groups of attributes which preserve functional dependencies. Entity driven: It discovers entities which are meaningful to application, and describe them.
How Relational Calculus is different from Relational Algebra? What do understand by TRC queries and DRC queries? Ans: Relational calculus contain two calculi, the tuple relati
a project based on normalization with first, second and third normalization. There need to be a diagram also
What does the extract statement do in extract datasets? The data is written to virtual memory by extract commands.
The Internal or Physical Level The collection of files permanently stored on secondary storage devices is called as the physical database. The internal or physical level is t
Explain weak and strong entity sets? Weak and Strong entity sets: A physically powerful entity set has a primary key. All tuples in the group are distinguishable through that k
Give the general form of SQL query? Select A1, A2............., An From R1, R2..............., Rm Where P
Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every
An employee record has the following structure struct employee { int eno; char name[22]; float salary; char dept[10];}; (i) Calculate the record size R in bytes.
Explain how the object classes are mapped to tables. Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizont
projects?
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