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
explain normalization,and give the examples 1NF,2NF,3NF,BCNF.AND FUNCTIONAL DEPANDENACY AND DECOMPOSITION TECHNIQUES.
Consider employee (e_no, e_name, e_salary, d_code), dept (d_code, d_name) and dependent (depndt_name, e_no, relation). Show the names of employees in purchase and accounts departm
What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a
What is transaction? Transaction is a unit of program implementation that accesses and possibly updated several data items.
Which operator is Cartesian product in relational algebra? Cartesian product in relational algebra is a binary operator. (It requires two operands. e.g., P X Q)
Write a query to define tables students and teachers as sub tables of people? Create table students of student under people Create table teachers of teacher under people
Write short notes on transaction state? A transaction may not always complete its implementation successfully such a transaction is termed aborted A transaction must be in o
differences between a classified catalog and a dictionary catalog
State the data flow diagram of functional model Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. Th
describe all the tables you have created. ?get table_name, status, num_rows, user_stats in user_tables system view ?get table_name, constraint_name, constraint_type in user_constr
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