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

List the set operations of sql, List the set operations of SQL? 1) Unio...

List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation

Implementation of integrity rules, Question 1 Describe the following- ...

Question 1 Describe the following- Clustering Indexing Question 2 Explain the following with suitable real time examples- Implementation of Integrity rules

Explain entity integrity and referential integrity rules, Explain entity in...

Explain entity integrity and referential integrity rules within relational model. Show how these are realized in SQL? Entity Integrity Rule - No primary key value could be nu

Enterprise applications integration, The figure below depicts the conceptu...

The figure below depicts the conceptual diagram of a banking system. (a) Describe one example relevant to the system in figure, for each of the 4 types of enterprise appl

Failure controlling methods, Failure Controlling Methods: Failures can be h...

Failure Controlling Methods: Failures can be handled using different recovery methods that are talk about later in the unit. But the first question is doing we really require recov

Transaction, Draw the precedence graph of the following schedule and determ...

Draw the precedence graph of the following schedule and determine whether the schedule is serializable. (Note that all instructions, except lock and unlock, are omitted. We assume

Create table statements for original database, MySQL statements for extendi...

MySQL statements for extending the database to incorporate new facilities Deliverables for submission You must submit the following deliverables in the Assignment Dropbox in

Advantages of data distribution, Advantages of Data Distribution The pr...

Advantages of Data Distribution The primary benefit of distributed database systems is the ability to access and share data in a reliable and efficient manner.

Write short notes on relational constraints, Write short notes on relationa...

Write short notes on relational constraints? Relational Constraints are: 1. NOT NULL 2. Unique 3. Primary key 4. Foreign key 5. Table check

DW Job Scheduling, Define a job scheduling strategy that will meet business...

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

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