We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

No.  03
Semester: Fall 2016

 

CS406 – Web Based Database Applications

Total Marks: 20

 

Due Date:

January 23, 2017

 

Submission Instructions:

 

Lectures to be Covered:  Week 9 to Week 11

Please read the following instructions carefully before submitting :

It should be clear that your will not get any credit if:

 

  • is submitted after due date.
  • Submitted does not open or file is corrupt.
  • is copied (From internet/ to from students).
  • You must write all code in PHP only.

 

 

Put your both DB Script (db.sql) file and PHP files in a folder, make its zipped file and upload your zipped file on the s interface of CS406 at VULMS. submitted in any other format will not be accepted and will be graded zero marks.

 

 

Objectives:

The purpose of this is to make you familiar with following topics:

 

  • MySQL-Structure (RDBMS , Creating Table for web application, Data Types)
  • Insert, Update, Delete, Connecting to MySQL using a client such as PHP MyAdmin or MySQL Workbench

 

 

 

 

Question 1: [20 marks]

 

Create a database named SaleHistory having following tables in it.

 

  1. Company
  2. User
  3. Customer
  4. SalesOrderProduct
  5. SalesOrder
  6. Address
  7. Product
  8. ProductGroup
  9. Group

 

Relationship between tables is shown in the given diagram, you have to make primary key in each table as per shown in the diagram. Also data type of each column should be according to your understanding and should be same for foreign key relationship. Each Primary key if it is of int data type then it should be auto increment.

 

 

For example you should use varchar for storing FatherName and int for Company ID etc.

 

 

 

 

 

Write PHP code in to connect this Database and show one row of data from each table by  writing the Table Name first then display the data of the first row of that table.

 

Note: You have to export your DB schema in an SQL file and submit db.sql file containing complete schema of your database with one row of data in each table and php file.

 

Deadline:

Your must be uploaded on or before the given due date. We shall not accept your through email after the due date.

 

 


+ 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)


Views: 201

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>>

 

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

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

RSS

Looking For Something? Search Here

Today Top Members 

HELP SUPPORT

This is a member-supported website. Your contribution is greatly appreciated!

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

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

.