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

Keys, #questiontypes of keys examples..

#questiontypes of keys examples..

Give an expression within sql for queries, Consider the following relations...

Consider the following relations:  S (S#, SNAME, STATUS, CITY)  SP (S#, P#, QTY)  P (P#, PNAME, COLOR, WEIGHT, CITY) Give an expression within SQL for each of queries b

Write short notes on data ware housing, Write short notes on data ware hous...

Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a

HRM, is Chipo carrying his baby

is Chipo carrying his baby

Define the term e-government, Question: (a) Define the term e-Governme...

Question: (a) Define the term e-Government and briefly explain, using appropriate examples, the aspects it covers. (b) Give four reasons as to why a country should adopt e

What is a homogeneous distributed database, What is a homogeneous distribut...

What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

What is the archtetype pattern, What is the archtetype/instance pattern? ...

What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among

Access data using logical database, If one requires to access data using...

If one requires to access data using Logical Database , the use of events is unavoidable. Yes, if someone wants to access data using Logical database then the use of events

What is known as sequential file organization, What is known as sequential ...

What is known as sequential file organization? In the sequential file organization, the records are kept in sequential order, according to the value of a "search key" of every

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