Concept of foreign key, Database Management System

Assignment Help:

Fundamentals of Database Management

1. Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls?

2. With a necessary example explain (i) Basic Constructs of E-R Modeling (ii) E-R Notations.

3. Explain the first 3 Normal Forms taking the help of an un-normalized relation and reducing it to 3 NF.

4. Explain the concept of Data Mining? How it is related with data warehouse.

5. Write the SQL queries using Data Manipulation Language (DML) statements.

a. Insert values into student table with field names using insert command
b. Display the table student using select command
c. Update student address in student table using update command.
d. Delete a row from student table

6. Create the payroll database considering table employee.

a. Do simple queries on the above database.
     i. list all information of the above both tables.
     ii. list the empno, ename, jobtitle,and hiredate of employee from the employee table.
b. list the name, salary of the employees who are clerks.
c. list the name,job,salary of every employee joined on certain date. (say ‘december 17,1980')
d. list name and annual salary of all the employees.
e. list the employees who have salary between certain range (say between Rs. 1000 & 2000)

 


Related Discussions:- Concept of foreign key

B+ tree, construct a B+ tree for the following set of key value (2,3,5,7,11...

construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six C. eigh

What is rdbms terminology for a row, What is RDBMS terminology for a row? ...

What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row

Complexity- drawbacks of data distribution, Complexity : A distributed DBMS...

Complexity : A distributed DBMS that is available, reliable, and secure is inherently more difficult than a centralised DBMS. Though, adequate data replication is essential to have

What is assertion, What is assertion? Mention the forms available. An a...

What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.

Example of sequences, Example : Create a sequence named SEQSS that starts a...

Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA

Execute sql queries, Consider the relations described below: PHYSICIAN (re...

Consider the relations described below: PHYSICIAN (regno, name, telno, city) PATIENT (pname, street, city) VISIT (pname, regno, date_of_visit, fee) Where the regno and pname ide

Question, I want to buy this but I want to see a couple sample questions fi...

I want to buy this but I want to see a couple sample questions first. http://www.expertsmind.com/library/what-happens-to-rms-error-for-the-training-data-set-51564843.aspx

Data control, Identify the need and use of data control through problem sol...

Identify the need and use of data control through problem solving, illustration

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd