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 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls?
Question 2 With a necessary example explain (i) Basic Constructs of E-R Modeling (ii) E-R Notations
Question 3 Explain the first 3 Normal Forms taking the help of an un-normalized relation and reducing it to 3 NF
Question 4 Explain the concept of Data Mining? How it is related with data warehouse
Question 5 Write the SQL queries using Data Manipulation Language (DML) statements
Question 6 Create the payroll database considering table employee
Explain the terms primary key, candidate key, alternate key and secondary key. In the given table identify every key? STUDENT(SID,Regno, Name, City) Primary Key: The prim
What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e
What are the two statements regarding transaction? The two statements regarding transaction of the form are:- A) Begin transaction B) End transaction
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.
Given the following set of functional dependencies {cf→ bg, g → d, cdg → f, b → de, d → c} defined on R(b,c,d,e,f,g) a. Is cf→ e implied by the FDs? b. Is dg a superkey?
Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.
Question: One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known
what are the limitations of dbms?
Describe relational model? Structure of relational data base Basic structure Database schema Keys Schema diagram Query languages
What is meant by buffer blocks and disk buffer The blocks residing temporarily in main memory are referred to as buffer blocks. The area of memory where blocks reside t
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