CS406 – Web Based Database Applications
Total Marks: 20
January 23, 2017
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:
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.
The purpose of this is to make you familiar with following topics:
Question 1: [20 marks]
Create a database named SaleHistory having following tables in it.
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.
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)
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>>
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