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

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!

 

Share This With Friends......

+ Click Here To Join also Our facebook study Group.

This Content Originally Published by a member of VU Students.

+ Prohibited Content On Site + Report a violation + Report an Issue


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


Views: 337

See Your Saved Posts Timeline

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

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

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