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:
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
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 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.
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.
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
+ 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)
Please up load the complete solution please
3rd normal form main karna kya hai in simple words????
DateSheetID Time Date Subject
StudentID DateSheetID Subject
you just place the values of your date sheet
date sheet id is unique which may be said to PK