Sunday, 23 July 2017

Assignment RDBMS ASSIGNMENT

Assignment
RDBMS ASSIGNMENT

Q1- What is codd’s Rule for RDBMS?
Q2- Write the short note on the given topic.

  • Foreign key
  • Primary key
  • Composite key

Q.3- Display the total no of employee working in each department
(syntax with suitable example) ?
Q4- What is Oracle Function .Explain in details?
Q5-Creat a table of employee with (emp_id, name, dept, design,
basic, DOB) the help of these columns name.