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!
Question 1 Discuss about second normal form and third normal form
Question 2 Write short note on 1) Data Manipulation Language 2) Data Definition Language
Question 3 Define the following terms 2) Entity 2) Keys
Question 4 Write down the characteristics of different types of storage devices. List (Cache, Main memory, Flash memory, Magnetic-disk storage, Optical storage, Tape storage)
Question 5 Differentiate between 1) Relational Data Model 2) Hierarchical Model
Question 6 What is Normalization? Explain different types of normal form
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
Data Fragmentation "Fragmentation includes decomposing the data in relation to non-overlapping component relations". Why do we require fragmenting a relation?
Describe file organisation? A file is organized logically as a sequence of records. These records are mapped onto disk blocks. A) Fixed-Length Records Type deposit=record
Explain the difference between using functions along with and without grouping attributes in relational algebra. Give examples. Ans: Group functions are used to group data of
aggregation
what is union compatable?
Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav
WHAT IS MEANT BY E-R MODEL
Whst is logical schema ? Logical schema is the entire database.
Problem: You are given the following schema 1. Flights(flno, from, to, distance) 2. Aircraft(aid, flno, aname, cruisingRange) 3. Certified(eid, aid) 4. Employees(eid, ena
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