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

CS614 Data Warehousing Assignment No.1 (Non-Graded) Spring 2014 Due Date 05-05-2014

CSData warehousing (CS614)

Assignment # 1 (NON-GRADED)

  Total marks = 20

                                                                                       Deadline Date = 05/05/2014

 

Please carefully read the following instructions before attempting the assignment.

 

Rules for Marking

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

 

  • The assignment is submitted after due date.
  • The submitted assignment does not open or file is corrupt.
  • The assignment is copied. Note that strict action would be taken if the submitted assignment is copied from internet or any other source.

 

1)      You should consult recommended books to clarify your concepts as handouts are not sufficient.

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

3)      You are advised to upload your assignment at least two days before Due date.

4)      This assignment file comprises of Seven (3) pages.

5)      Assignment is non graded and will not contribute any marks in final grades

 

 

Important Note: 

 

Assignment comprises of 20 Marks. Note that no assignment will be accepted after due date via email in any case (whether it is the case of load shedding or emergency electric failure or internet malfunctioning etc.). Hence, refrain from uploading assignment in the last hour of the deadline, and try to upload Solutions at least 02 days before the deadline to avoid inconvenience later on.

 

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


Online Date sheet management

 

Online date sheet management system lets the students of different universities to create their date sheet online as per their own convenience. System operates in two modes:

 

Admin mode:

 

Admin of the system provides the configuration data e.g. the exam starting and ending dates, available centers and subject details. Admin activates the date sheet module for a specified time after which it is deactivated.

 

Student mode:

 

Students of the system login through their ID and create date sheet for the selected examination as per their availability. Each Student selects the subject, day and exam center. After clicking the confirm button, the paper of the selected subject is scheduled on that day at the specified exam center. In this way student schedules all of the subjects. After clicking the submit button, the date sheet is locked and email is sent to the student with details of the date sheet. Once the date sheet is locked by the student, he/she cannot change it.

 

 

Question:

 

Consider the following portion of the diagram. Convert it into relational tables up to 3NF.

Note: Just show the tables in 3NF, no need to show tables in 1NF and 2NF

+ How to Follow the New Added Discussions at Your Mail Address?

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 2234

.

+ 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?)

+ Click Here To Join (Our facebook study Group)

Attachments:

Replies to This Discussion

start discussion plz and give some examples

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.

Third Normal Form

The third normal form requires that all columns in a relational table are dependent only upon the primary key. A more formal definition is:

A relational table is in third normal form (3NF) if it is already in 2NF and every non-key column is non transitively dependent upon its primary key. In other words, all nonkey attributes are functionally dependent only upon the primary key.

Table PARTS is already in 3NF. The non-key column, qty, is fully dependent upon the primary key (s#, p#). SUPPLIER is in 2NF but not in 3NF because it contains a transitive dependency. A transitive dependency is occurs when a non-key column that is a determinant of the primary key is the determinate of other columns. The concept of a transitive dependency can be illustrated by showing the functional dependencies in SUPPLIER:

SUPPLIER.s#
—> SUPPLIER.status
SUPPLIER.s#
—> SUPPLIER.city
SUPPLIER.city
—> SUPPLIER.status
Note that SUPPLIER.status is determined both by the primary key s# and the non-key column city. The process of transforming a table into 3NF is:

Identify any determinants, other the primary key, and the columns they determine.
Create and name a new table for each determinant and the unique columns it determines.
Move the determined columns from the original table to the new table. The determinate becomes the primary key of the new table.
Delete the columns you just moved from the original table except for the determinate which will serve as a foreign key.
The original table may be renamed to maintain semantic meaning.
To transform SUPPLIER into 3NF, we create a new table called CITY_STATUS and move the columns city and status into it. Status is deleted from the original table, city is left behind to serve as a foreign key to CITY_STATUS, and the original table is renamed to SUPPLIER_CITY to reflect its semantic meaning.

Great teacher

Very Comprehensive...Good Work

AOA to all

i think one table is exam and second table is student.

exam table adding exam center and paper and subject

and student table adding datesheet and paper.

its right or not?

plz give me ur opinion....

 

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....

thnxx sir 

kindly anybody give solution plz

First  show relation among all antities

Then show relation in 3rd normal form 

Then creat a relational tables to show relations independently.

Have we define attributes also for every table???

To complete the given table first study ER relation ship diagram which help out to make the 3NF table 

RSS

Latest Activity

Rana Ali posted a discussion
1 minute ago
Purple Work replied to + M.Tariq Malik's discussion MTH302 Business Mathematics & Statistics Assignment No 01 Fall 2019 Solution & Discussion in the group MTH302 Business Mathematics & Statistics
1 minute ago
Purple Work joined + M.Tariq Malik's group
1 minute ago
Mutasadiq Iqbal replied to ayesha's discussion CS614 Assignment NO.1 Fall 2019 Solution&Discussion Due date: 14 Nov 2019 in the group CS614 Data Warehousing
2 minutes ago
Mutasadiq Iqbal replied to ayesha's discussion CS614 Assignment NO.1 Fall 2019 Solution&Discussion Due date: 14 Nov 2019 in the group CS614 Data Warehousing
3 minutes ago
Mutasadiq Iqbal replied to ayesha's discussion CS614 Assignment NO.1 Fall 2019 Solution&Discussion Due date: 14 Nov 2019 in the group CS614 Data Warehousing
3 minutes ago
Profile IconMutasadiq Iqbal and Somo Khan joined + M.Tariq Malik's group
3 minutes ago
Zohan joined + M.Tariq Malik's group
3 minutes ago
Rana Ali liked Rana Ali's discussion Tell some words in the Shan of Hazart Muhammad (S.A.W)
3 minutes ago
Rana Ali liked Rana Ali's discussion Tell some words in the Shan of Hazart Muhammad (S.A.W)
4 minutes ago
Zohan joined + M.Tariq Malik's group
4 minutes ago
Zohan joined + M.Tariq Malik's group
4 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MTH501 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 19-11-2019 in the group MTH501 Linear Algebra
10 minutes ago
+ M.Tariq Malik liked + M.Tariq Malik's discussion MTH501 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 19-11-2019
11 minutes ago
Rana Ali liked + ! ! ! ! ! ! maho+++'s discussion WASEYAT RASOL PAK S.A.W.W
11 minutes ago
+ M.Tariq Malik added a discussion to the group MTH501 Linear Algebra
11 minutes ago
+ AiM liked + ! ❤️ ░S░I░N░G░E░R's discussion Accurate Depiction Of Poetic Beauty
11 minutes ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MCM301 Communication skills Online Quiz No 01 Fall 2019 Solution Discussion in the group MCM301 Communication skills
15 minutes ago
Babar ali joined + M.Tariq Malik's group
15 minutes ago
MEHWISH SHAFIQ updated their profile
18 minutes ago

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

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