CS409 Practical All Labs by VUBuddy

Identify Candidate Keys and Primary Key for the given table “Employee”.

Task 4:

Emp ID CNIC Salary Designation, Email ID

Task 3:

Candidate Keys: {Roll Number}, {CNIC#}, {Mobile#} Name}, {Roll Number, Student Name, Father Name, CNIC#, Mobile#, Degree Program, CGPA} Super Key: {Roll Number}, {CNIC#}, {Roll Number, Student Name}, {CNIC#, Student Identify Super Keys, and Candidate Keys for the given table “Student”.

Task 2:

Number Program Roll Student Father CNIC# Mobile# Degree CGPA

Task 1:

house gets a new project to develop the database of an ABC university. As a part of database Suppose, you are hired as a junior database developer in an XYZ software house. The software

Tables

Identifying Super Keys, Candidate Keys and Primary key from Database

Lab 01 – Week 01

Dpt ID Dpt Name Emp ID Tel No Dpt ID, Dpt Name, Emp ID, Tel No Create another table named “Department” with following attributes: Emp ID CNIC Salary Designation Email ID

Task 3:

Surrogated Keys: {Application Number} Identify Surrogated Keys for the given table “Student”.

Task 2:

Number Program Roll Student Father Name CNIC#, Mobile#, Degree CGPA

Task 1:

gets a new project to develop the database for a new university. As a part of database Suppose, you are hired as a junior database developer in an Abbot’s solution. The software house

Identifying Surrogated Keys and Foreign key from Database Tables

Lab 02 – Week 02

Draw Entity Relationship Diagram (ERD) for it.

Task 2

Messages msg_id, message_body, sender_id Discussion Thread Thread_id, title Task Task_id, title, creation_date, deadline, User user_id, name Role role_id, name Entities Attributes Identify Entities, their attributes, relationships among entities in above scenario

Task 1

You’re required to perform the following tasks according to above scenario. complete progress can be viewed for the specific task. can post messages in Discussion Threads. User can also able to edit tasks and set deadlines. A Each user has to perform a specific role. User can create tasks along with discussion threads. Users manage and track projects, deadlines, schedules, and other workflow processes. The ABC Company aims to develop a project management software which enables its users to