Blogger Text

My Aim to Provide you quality contents, Tips & Tricks, Software, Microsoft Office, Graphic Editing (Adobe PhotoShop, After Affects, Illustrator, inDesign) Corel Draw, Corel Video Studio, Cyberlink PowerDirector, Power ActionCinema, Tutorials about Blogging and VU Assignments, Quizes & GDB Solutions and Much More... at regular Basis
                                     ***    Kindly Subscribe our Official YouTube Channel "INFOPALACESS OFFICIAL-Tuts: in this channel we upload Programming (C,C++,C# JAVA, PHP), Web Development, Graphics Editing and Microsoft Office Step by Step Tutorials from bigginer to Advance Level. We also provide free online courses at our YouTube Channel. ***   Graded Assignments/Quizes and GDB will start in Next Week. Solution ideas of All assignments, Quizes and GDB will be available here. If you have any problem regarding this then you can contact us.

CS614 Assignment 1 Spring 2019 Solution Working on..

 Info!  Please Don't Make 100% copy of your assignment Solution. Make some changes so that your solution look differrent than other students. If you make Exact copy of then you can get marks zero.

Solution Idea of CS614 Assignment No 1 2019 Fundamental Algorithm Due Date 15-05-2019



Problem:   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%202019%20-%20Assignment%201%20-%20Sample%20Data.xlsx

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 (attributeI, attributeX, …)

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.

Solution:

Watch the Video below to know that how to solve this assignment with step by step guide and references

Reference: This top is covered at Page 47 at Handsout


How to Submit:

You need to submit this file in Microsoft Word (doc, docx) file formate on or before due date.



If you have any Problem regarding your assignment Solution then you can contact Us or leave a Comment below. You can also subscribe our Official YouTube Channel to get guided videos of all assignments, quizes or GDB. You can also join our Official WhatsApp Groups by Click on the links Below.

DescriptionLinks
YouTube Channel:Infopalacess Official Tuts
WhatsApp Group 1:VU Assignments Portal by Infopalacess 2
WhatsApp Group 2VU Assignments Portal by Infopalacess 2
WhatsApp Group 33- VU Solutions by Infopalacess

Post a Comment

6 Comments

  1. file dwnld to honi rhi hmara bhi khayal kia kro easy ho jay

    ReplyDelete
    Replies
    1. ye ap ne apne pc ma banani ha q k is ma server pc ki id uthata ha aur phr ap pane pc mai bana kr share krni ha screen shot, but ma ap ko jo query commands use ki ha usi file share kr deta ha just ap ne copy paste kr query run kro ge tu ap ki table database ma ban jaye ga aik min mai .... i will share i very soon

      Delete
    2. Thanks sir, plz share file

      Delete
  2. dear brother kindly help kr dain aaj last date hai

    ReplyDelete