We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

Assignment No. 3 (Non-graded) Database Management System (CS403) Deadline Date: 21/01/2014

 

Database Management System (CS403)

Assignment No. 3 (Non-graded)

                                                                                                          Total marks = 20

   Deadline Date: 21/01/2014

                              

Please carefully read the following instructions before attempting the assignment.

 

 Deadline

Your assignment must be uploaded before or on   21th  January 2014.

 

Rules for Marking

It should be clear that your assignment will not get any credit if:

1. The assignment is submitted after due date

2. The assignment is copied

3. You are supposed to submit your assignment in .doc / Docx format. Any other formats like scan    images, PDF, Zip, rar, bmp etc will not be accepted.

 

For any query please contact: CS403@vu.edu.pk

 

                                                                        

Objectives

The objectives of this assignment are,

 

  1. Giving the idea of normalizing the relations
  2. Providing an understanding of different types of normalization i.e. 1st,2nd and third normal form

 

 

Scenario

Introduction:

The Educational and Recruitment Testing System (ERTS) is an organization that conducts academic performance evaluation tests. It is an autonomous, testing organization, conducts tests for admissions, scholarships, and recruitment purposes. It is governed by a Management Committee (Admin). ERTS is a testing and assessment organization facilitating in producing educated and market competitive human resource.

 

The whole system can be divided into following five different modules:

  1. ERTS Tests and Products
  2. Applicant Registration
  3. Application processing by ERTS
  4. Test
  5. Result

Detail of each module is given below:

  1. ERTS Tests and Products:

The system will use modern technologies for developing tests, test conduction, e-marking and compilation of results.

ERTS is assumed to conduct tests for the following categories:

  • Academic Tests
  • Recruitment Tests

 

  1. 2.      Applicant Registration:

The applicants who are seeking for admission (college/university) or recruitments, which requires an ERTS Test for its eligibility criteria, will have to apply for ERTS Test.

The applicant will be either already registered or will a new applicant. Already registered applicants could be login to the system by entering their username and password and could apply for their interested test category.

In case the applicant has not been registered yet, he will first register himself by filling and submitting the online application form available at ERTS website. After submitting the application form, the applicant will receive a confirmation message and the application will be stored in the ERTS database. After that the applicant will print the filled application along with a bank deposit slip, and will deposit the required amount in the mentioned branches of banks. He will post the application form along with the bank deposit slip on the mentioned address.

  1. 3.      Application processing by ERTS:

The applications received by ERTS will be processed according to required criteria and the eligible candidates will be issued a roll number slip. The accepted and rejected both applications will be stored in the ERTS database.

  1. 4.      Test:

On the mentioned test date the applicant appears in the test at allocated center.

The invigilator verifies the candidates via their original NIC and roll number slip. The invigilator starts distributing the question booklet and answer sheet according to the selected test category. The candidate attempts the test and returns both the answer sheet and question booklet to the respective invigilator.

  1. 5.      Result:

The invigilator will hand over both the answer sheet and question paper to the staff of Educational and Recruitment Testing System (ERTS). The staff will arrange the answer sheets in proper sequence by serial number. The staff starts marking of answer sheets through the scanned process of the system and the system will match the attempted questions with the stored question bank and will mark each question as correct or incorrect. The system will calculate the total marks and will store in the database. The system will declare the online result as well as dispatch the result card to successful candidates after approval from the management committee.

 

Tasks:

 

In this assignment you will focus on the task(s) given below:

 

1. You are given unnormalized relation as shown below.You are required to perform normalization (1st to 3rd Normal forms) on the given relation and write the resultant relations as an output after each normal form.

 

 

Relation:

 

 

APPLICANT( applicant_Id, applicant_Name, father_Name, gender, applicant_Dob, cell_no, ,application_Id, qualification , application_Name)

 

 

Applicant_Id, Applicant_Name

father_Name

gender

applicant_Dob

cell_no

application_Id

qualification

application_Name

ap-1001,

 

Hammad

Sajid Ali

Male

07/04/1987

0333-9895097,

0312-5554442

appl-01

MCS

GAT-Gen

ap-1002,

 

Ali

Umair

Male

01/02/1988

0333-5556661

appl-02

MBA

GAT-Sub

ap-1003,

 

Salma

Maqsood

Female

04/05/1988

0300-2002001

appl-03

BCS

GAT-Gen

ap-1004,

 

Asad khan

M. Faiz

Male

06/01/1987

0345-1999888,

0333-2223334

 

appl-04

BBA

NAT

 

 

 

You have to perform all these tasks given above in your solution file.

 

Note: First perform 1st NF (write the resultant relations) then 2nd NF (write the resultant relations)  and at the end 3rd NF (write the resultant relations). Use all concepts you have studied so far and techniques in order to normalize the realtion.

 

+ Click Here To Join also Our facebook study Group.

..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 3454

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Attachments:

Replies to This Discussion

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.

non graded  pe sad  + Maryam Malik + sis kya ho gya hai apko 

non graded... gud

In 1st normal form, due to "cell no" attribute rows are created for Applicant "Hammad" and "Asad khan"

is dafa itni non graded assignments aa rahi hain Khuda khair karay  aesa na ho bad mein pata chaly k in mein participate na krny waly students fail 

After performing first Normal form..Am I right??

I-NF:

Applicant id

Applicant name

Father name

Gender

Applicant DOB

Qualification

Ap1001

Hammad

Sajid ali

Male

07/04/1987

MCS

Ap1002

Ali

Umair

Male

01/02/1988

MBA

Ap1003

Salma

Maqsood

Female

04/05/1988

BCS

Ap1004

Asad khan

M-Faiz

Male

06/01/1987

BBA

 

 

 

 

Cell no.

Applicant id

Application id

Application name

0333-9895097

Ap1001

App1-01

Gat-Gen

0312-5554442

Ap1001

App1-01

Gat-Gen

0333-5556661

Ap1002

App1-02

Gat-Sub

0300-2002001

Ap1003

App1-03

Gat –Gen

0345-1999888

Ap1004

App1-04

Nat

0333-2223334

Ap1004

App1-04

Nat

 

 

 

 

 

 

Dear fellows please check is it correct or not?

applicant id and name will have separate attributes???

dear sis kia ye 1st normal form ko satisfy nhi kerta jo mein ne post kia hai?

Solution:

1st NF table:

 

Applicant

Id

 

 

Applicant

name

 

Father_name

 

Gender

 

 

Applicant DOB

 

Cell_No

 

Application

Id

 

 

Qualification

 

 

Application

Name

 

Ap-1001

 

Hammad

 

Sajid  Ali

 

Male

 

07/04/1987

0333-9895097

Appl-01

MCS

 

GAT-Gen

Ap-1001

 

 

Hammad

 

Sajid ali

 

Male

 

07/04/1987

0312-5554442

Appl-01

MCS

GAT-Gen

Ap-1002

 

 

Ali

 

Umair

 

Male

 

01/02/1988

0333-5556661

Appl-02

 

MBA

GAT-Sub

Ap-1003

 

 

Salma

 

Maqsood

 

Female

 

04/05/1988

0300-2002001

Appl-03

BCS

GAT-Gen

Ap-1004

 

Asad

Khan

 

M.Faiz

 

 

Male

 

06/01/1987

0345-1999888

Appl-04

BBA

NAT

Ap-1004

 

 

Asad khan

 

M.Faiz

Male

 

06/01/1987

0333-2223334

Appl-04

BBA

NAT

         

      Resultant relation:

     Appl-id,appl-name,father-name,gender,appl-dob,cell-no,applation-id,qualification,application-   name

2nd NF:

Applicant table:

Applicant

Id

Applicant-name

Father-name

Gender

Applicant-DOB

Cell-no

Ap-1001

 

Hammad

 

Sajid  Ali

 

Male

 

07/04/1987

0333-9895097

Ap-1001

 

 

Hammad

 

Sajid ali

 

Male

 

07/04/1987

0312-5554442

Ap-1002

 

 

Ali

 

Umair

 

Male

 

01/02/1988

0333-5556661

Ap-1003

 

 

Salma

 

Maqsood

 

Female

 

04/05/1988

0300-2002001

Ap-1004

 

Asad

Khan

 

M.Faiz

 

 

Male

 

06/01/1987

0345-1999888

Ap-1004

 

 

Asad khan

 

M.Faiz

Male

 

06/01/1987

0333-2223334

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Applicatiom table:

 

 

Application

Id

 

 

Qualification

 

 

Application

Name

 

Appl-01

MCS

 

GAT-Gen

Appl-01

MCS

GAT-Gen

Appl-02

 

MBA

GAT-Sub

Appl-03

BCS

GAT-Gen

Appl-04

BBA

NAT

Appl-04

BBA

NAT

 

 

 

 

 

 

 

 

 

 

3rd NF:

Applicant information table:

 

Applicant

Id

Applicant-name

Father-name

Gender

Ap-1001

 

Hammad

 

Sajid  Ali

 

Male

 

Ap-1001

 

 

Hammad

 

Sajid ali

 

Male

 

Ap-1002

 

 

Ali

 

Umair

 

Male

 

Ap-1003

 

 

Salma

 

Maqsood

 

Female

 

Ap-1004

 

Asad

Khan

 

M.Faiz

 

 

Male

 

Ap-1004

 

 

Asad khan

 

M.Faiz

Male

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Application information table:

 

Application

Id

 

 

Qualification

 

 

Application

Name

 

Appl-01

MCS

 

GAT-Gen

Appl-01

MCS

GAT-Gen

Appl-02

 

MBA

GAT-Sub

Appl-03

BCS

GAT-Gen

Appl-04

BBA

NAT

Appl-04

BBA

NAT

 

 

 

 

 

 

 

 

 

Applicant biodata table:

 

Applicant

Id

 

 

Applicant

name

 

Father_name

 

Gender

 

 

Applicant DOB

 

Cell_No

 

Application

Id

 

 

Qualification

 

 

Application

Name

 

Ap-1001

 

Hammad

 

Sajid  Ali

 

Male

 

07/04/1987

0333-9895097

Appl-01

MCS

 

GAT-Gen

Ap-1001

 

 

Hammad

 

Sajid ali

 

Male

 

07/04/1987

0312-5554442

Appl-01

MCS

GAT-Gen

Ap-1002

 

 

Ali

 

Umair

 

Male

 

01/02/1988

0333-5556661

Appl-02

 

MBA

GAT-Sub

Ap-1003

 

 

Salma

 

Maqsood

 

Female

 

04/05/1988

0300-2002001

Appl-03

BCS

GAT-Gen

Ap-1004

 

Asad

Khan

 

M.Faiz

 

 

Male

 

06/01/1987

0345-1999888

Appl-04

BBA

NAT

Ap-1004

 

 

Asad khan

 

M.Faiz

Male

 

06/01/1987

0333-2223334

Appl-04

BBA

NAT

         

 please chek this solution

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....

u right zahra bec in 1NF we have no duplication in each row.

RSS

Today Top Members 

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service