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

Solution Required

Assignment No. 03

Graded
Semester: Spring 2018

CS310: Open Source Web Application Development

Total Marks: 20

 

Due Date: July 31, 2018

 

 

General Instructions:

 

Please read the following instructions carefully before submitting assignment. It should be clear that your assignment will not get any credit if:

 

§  The assignment is submitted after due date.

§  The submitted assignment does not open or file is corrupt.

§  Assignment is copied (partial or full) from any source (websites, forums, students, etc.)

 

Note: You have to upload your assignment solution only in zip format. Zip file includes .sql file of MySQL containing your created database and values in it too.

 

Objective:

 

The objective of this assignment is to provide hands on experience of:

 

·         Installing and configuring MySQL

·         Dealing with MySQL Database (Creation of DB)

·         Looking into DB design of suggested scenario

 

Tools to use:

 

-          XAMP / WAMP server

-          MySQL (Any Windows OS supported version)

-          MySQL Workbench (Optional and Any version available online for free for Windows OS)

 

Important Links:

 

-          https://www.mysql.com/products/workbench/

-          https://www.mysql.com/

-          https://www.mysql.com/downloads/

 

For any query about the assignment, contact at cs310@vu.edu.pk

 

 

Problem Statement:

Part of database schema of purchase management system is provided below.

 

DATABASE SCHEMA / DATA DICTIONARY

(Purchase Management System)

 

Table Name: STUDENT

Attribute Name

Data Type

Student_ID

 

Student_Name

 

Father_Name

 

Father_Occupation

 

DoB

 

Student_Address

 

phone_no

 

e-mail

 

Enrolled_Program

 

 

 

Table Name: COURSE

Attribute Name

Data Type

Course_Code

 

Course_Name

 

Developed_By

 

Credit_Hours

 

 

 

 

Table Name: SEMESTER

Attribute Name

Data Type

Semester_ID

 

Semester_Name

 

 

 

 

 

 

 

 

Table Name: FACULTY

Attribute Name

Data Type

Faculty_ID

 

Faculty_Name

 

CNIC

 

Mailing_Address

 

Phone_Number

 

Latest_Degree

 

Designated_Dept

 

 

 

 

Table Name: ENROLLMENT

Attribute Name

Data Type

Student_ID

 

Course_ID

 

Semester_ID

 

Faculty_ID

 

 

Instructions Regarding Assignment Solution::

1 - You have to fill these five tables with appropriate data type (Data type must be supported for MySQL DBMS).

2 – Create Database in MySQL named as your VU Student ID.

2 - Write SQL query / code to create sample tables in MySQL.

3 – Enter two valid entries in each designed table in MySQL.

What to submit as your Assignment Solution::

Take dump of Database along with values in .sql format and name it after your VU ID for example; BS123456789.sql

You have to take dump of your DB as instructed in the link below;

https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html

 

 

Best of Luck!

 

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

.

+ 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 are closed for this discussion.

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.

 

Note:-

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.

&

.•°How to Download past papers from study groups°•.

 

Please Click on the below link to see…

.... How to Find Your Subject Study Group & Join .... 

 

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

RSS

Latest Activity

BIA replied to BIA's discussion Ehsaas...
32 seconds ago
BIA liked + ! ✨ ░S░I░N░G░E░R's discussion Issuance of First Voucher to Continuing Students (Fall, 2019)
6 minutes ago
BIA liked BIA's discussion Aurat ki Izaat krna......
7 minutes ago
BIA liked BIA's discussion Afsoos.. :(
7 minutes ago
BIA liked BIA's discussion Marad ka kaam Aurat ko samjhna nahi....
7 minutes ago
BIA liked BIA's discussion Jothii Shaan . .
7 minutes ago
BIA liked + !! SARAH's discussion + i dnt knw where it could fit into ur story but it is......!!
7 minutes ago
BIA liked BIA's discussion Aurat ko khelona smjhny waly. . . . .
7 minutes ago
BIA liked BIA's discussion Ehsaas...
7 minutes ago
BIA liked BIA's discussion KhobSorut Nasihaat :)
7 minutes ago
BIA liked BIA's discussion Golden Words. .
7 minutes ago
BIA liked BIA's discussion Itnaa Karo . . ..
7 minutes ago
BIA liked BIA's discussion teen chezon main kabhi sharam mehsos mat karna. . . .
7 minutes ago
BIA posted discussions
9 minutes ago
+ !! SARAH liked BIA's discussion Aurat ko khelona smjhny waly. . . . .
19 minutes ago
+ !! SARAH liked BIA's discussion Ehsaas...
19 minutes ago
+ !! SARAH replied to BIA's discussion Ehsaas...
19 minutes ago
+ !! SARAH posted discussions
23 minutes ago
+ !! SARAH replied to + Iuuoɔǝut+'s discussion Mind blowing mehndi design ...
27 minutes ago
+ !! SARAH liked + Iuuoɔǝut+'s discussion Mind blowing mehndi design ...
36 minutes ago

Today Top Members 

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

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