Assignment No. 03
CS310: Open Source Web Application Development
Total Marks: 20
Due Date: July 31, 2018
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.
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)
For any query about the assignment, contact at email@example.com
Part of database schema of purchase management system is provided below.
DATABASE SCHEMA / DATA DICTIONARY
(Purchase Management System)
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;
Best of Luck!
+ 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 are closed for 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.
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
Please Click on the below link to see…
P.S: Please always try to add the discussion in proper format title like “CS101 Assignment / GDB No 01 Solution & Discussion Due Date: ___________”