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

Apriori algorithm-find all frequent large itemsets, Your friend owns a comp...

Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t

Key, Q.   Explain the terms key constraints participation constraints and m...

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

What is a candidate key, What is a candidate key? Minimal super keys ar...

What is a candidate key? Minimal super keys are known as candidate keys.

Lack of standards and experience, Lack of standards and experience: The la...

Lack of standards and experience: The lack of standards has considerably limited the potential of distributed DBMSs. As well, there are no tools or methodologies to help users cha

Database, . Ashutosh Dubey who is the director of Gyan Gurukul want a three...

. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan Gurukul Company that provide better security also design a data abstraction

What are the advantages of object id, What are the advantages of object ID?...

What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing  ii) IDs are completely independent of the changes in data v

Relational algebra, Relational Algebra is a set of basic operations used to...

Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of re

Join relation of two tuples, Consider the join of a relation R with relatio...

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is: If R has m tuples and S has n tuples then maximum siz

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