Page 404 - Trackpad 402_Class-X_Final
P. 404
STATEID Number[NUMERIC] Bill Number[NUMERIC]
Phone Number[NUMERIC] Amount_Billed Number[NUMERIC]
Mobile Number[NUMERIC] Amount_Paid Number[NUMERIC]
ContactPerson Text[VARCHAR]
CreditLimit Number[NUMERIC]
Table Name : STATE
Field Name Data Type
StateID Number[NUMERIC]
StateName Text[VARCHAR]
Forms/Query/Relationship:
Set Relation Between Tables (CustID - Customer To BillDetails and StateID – Customer To State).
Generate a query that will display the records of Customer Table along with Statename and Billing details of the
customer. The query should calculate the balance amount of the customer.
Design a Form to display the customer details.
Update any CustID in CUSTOMER table and verify if the same gets updated in BILLDETAILS table.
21 st #Productivity & Accountability
DATABASE Century #Information Literacy
Skills
1. Create a Database-SCHOOL with the given tables:
STUDENT
Admno varchar(5) [primary key]
Name varchar(20)
Address varchar(30)
City varchar(10)
Phoneno number(10)
Dob date
MARKS
Rollno number(3) [primary key]
Admno varchar(5)
Tcode varchar(5)
Test1 number(6,2)
Test2 number(6,2)
404 Trackpad Information Technology-X

