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


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

CS614 Data Warehousing Assignment No 01 Solution & Discussion Due Date: 15-05-2019

CS614 Data Warehousing Assignment No 01 Solution & Discussion Due Date: 15-05-2019

+ 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: 3706

.

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

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

Discussed & be touched with this discussion. After discussion a perfect solution will come in a result at the end.

 

“How to Join Subject Study Groups & Get Helping Material”

 

P.S:    Please always try to add the discussion in proper format title like “CS101 Assignment / GDB No 01 Solution & Discussion Due Date: ___________”

Assignment

 

 

XYZ company was established in 1989 in Karachi and deals in the business of garments export. There are 250 permanent employees that are working with XYZ company. XYZ’s admin department is maintaining employee’s leave records in hard form. The leave form currently in practice is shown below:

 

Now XYZ company wants you to design a Database solution for their organization, you are required to develop a database that is normalized up to the 3rd Normal form. In the future, this database can be used for developing front end application.

 

A raw table structure along with attributes are provided by the XYZ’s management to start your working on it, is as following;

 

 

employeeLeaveForm (employeeID, empName, designation, officeName, dateOfFill, leaveType, leaveFromDate, leaveToDate, leaveReason, leaveAddress, leaveContactNo, leaveProcessDate, leaveStatus, leaveProcessedBy),

 

Sample data for the table is provided on VULMS for your reference. To view / download this data, use the following link;

 

https://vulms.vu.edu.pk/Courses/CS614/Downloads/CS614%20-%20SP%2020...

 

 

 

You have to use exact given attributes names while normalizing this table to 3rd Normal form.

 

 

Instructions to solve assignment:

 

-          Use table employeeLeaveForm and attributes in it. You are not allowed to remove any of the provided attributes

-          You may introduce new tables by using the same attributes in employeeLeaveForm and also add new attributes for indexing / normalization purpose

-          You are also required to declare Primary and Foreign Keys from the provided list of attributes (Also represent them with suitable DB notation while writing table schema)

-          Transform the table in 3rd normal form step by step i.e. First Normal form transformation then into 2nd normal form and then into 3rd. Also, mention the title of Normal Form before the transformation.

-          Direct transform relation into 3rd normal form would result in zero marks whether your solution is correct. And this will be imposed strictly while marking this assignment with no later excuses.

-          Example of resultant tables / solution should be in the form provided below:

tableNo1 (attribute1, attribute2, …)

tableNo2 (attributeX, attributeY, …)

tableNo3 (attributeIattributeX, …)

 

attribute1, attributeX and attributeI (with solid underline) are primary keys in tableNo1, tableNo2 and tableNo3 respectively while attribute (With dotted underline) is foreign key in tableNo3 from referee tableNo2.

 

Deadline:

Your assignment must be uploaded on VULMS on or before May 15, 2019. While May 16, 2019 will be a bonus day for assignment submission. After the bonus day, no assignment would be entertaine

plz solution idea chaheya

mly to mjy b dy dena koi

solution Please.

mujhy to zara samajh nhi ae k sql me bnany k bd kia krna hy

SQL main bnana h mjy to ye b ni pta

Listen Lecture NO 6 i didnot make yet..still confusion

Solution ?

i also need

solution idea check it 

check this file ....

Attachments:

RSS

Latest Activity

+ ! ! ! ! ! ! ! ! ! AG replied to + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion Happy Birth Day Zargiyah (Tasha <3)
2 seconds ago
+ Danial liked + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion Happy Birth Day Zargiyah (Tasha <3)
5 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Muhammad Younas Rajpoot's discussion ECO404 assignment 1 fall semester dated 19-11-2019
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked waqas ahmad's discussion isl 201
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked zobialatif's discussion hazrat ali says
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + IUUOƆƎUT +'s discussion Kabhi aye haqeeqat e muntizir
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Abdul Majid Jamil's discussion for assignment of zoogy on topic wildlife counting
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Azhar Sagar's discussion How to make srs Software Requirements Specification
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Moji's discussion MCM301 assignment no 1
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked Aijaz khan's discussion CS608 - Software Verification and Validation Assignment No. 2 Need Solution
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked 彡JK彡 ❤️'s discussion If you have sOmething stupid to saY............
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked zohaib iftikhar's discussion ...* NASEEB TAK RASAI ...*
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked 彡JK彡 ❤️'s discussion Don't Look for Perfection........ LOVE lies in imperfection
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked +! ! ! "Asнтαℓғαн's discussion Happy wala Birthday tashy patashy ❤ (Tasha)
6 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion Happy Birth Day Zargiyah (Tasha <3)
7 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + IUUOƆƎUT +'s discussion کہو تو لوٹ جاتے ہیں ۔ ۔ ۔
7 minutes ago
+ ! ! ! ! ! ! ! ! ! AG liked + IUUOƆƎUT +'s discussion How Can You Get Secured of Being Banned On Ning
7 minutes ago
Danial added a discussion to the group MCM501 Advertising for Print and Electronic Media
29 minutes ago
Zareen replied to + IUUOƆƎUT +'s discussion How Can You Get Secured of Being Banned On Ning
32 minutes ago
khurram us salam replied to + M.Tariq Malik's discussion ACC501 GDB Fall 2019 Solution & Discussion in the group ACC501 Business Finance
32 minutes ago

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

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