IMS 133 EXAM

https://drive.google.com/open?id=0BxefRQsCvoVFbnVfVnRRbW13bG8&authuser=0

EXAM - CLICK THE LINK TO START

CSC127 EXAM - WEB DEVELOPMENT

CSC112 FINAL EXAM

I. Do the following in Console Application

1. Let the user input a grade from 65 to 100 and give the equivalent remark

FAIL = 65-74

FAIR = 75-80

GOOD = 81-85

VERY GOOD = 86 - 90

EXCELLENT = 91-100

2. DISPLAY  SERIES OF EVEN NUMBERS FROM 48-100

3. Let the user input username and password. The user is only allowed to make 4 attempts. If the number of attempts becomes 0, close the program

II. Do the following in Windows form

3. Let the user input username and password. The user is only allowed to make 4 attempts (make sure to display the available number of attempts in label) If the number of attempts becomes 0, disable the textboxes and button.

SQL JOINING

create database dbABCorp

create table tblcustomers
(
cid int primary key,
cname varchar (50),
caddress varchar (50),
cgender varchar (50),
)

create table tblproducts
(
pid int primary key,
pname varchar (50),
price float,
quantity int,
)

create table tblorders
(
orid int primary key,
orno int,
cid int foreign key references tblcustomers (cid),
pid int foreign key references tblproducts (pid),
quantity int,
total float,
)

select * from tblorders


insert into tblcustomers values (1,'Remo','Cebu','Male')
insert into tblcustomers values (2,'Jake','Cebu','Male')


insert into tblproducts values (1,'TV',12000,10)
insert into tblproducts values (2,'CELLPHONE',8000,10)
insert into tblproducts values (3,'FAN',1000,10)

select * from tblorders
insert into tblorders (orid,orno,cid,pid,quantity) values  (1,1,1,2,2)

select orid,orno,tblorders.cid,tblcustomers.cname,tblorders.pid,tblproducts.pname,tblproducts.price,tblorders.quantity,(tblorders.quantity*tblproducts.price) as 'Total Amount' from tblorders 
inner join tblcustomers on tblcustomers.cid=tblorders.cid
inner join tblproducts on tblproducts.pid=tblorders.pid

insert into tblorders (orid,orno,cid,pid,quantity) values  (2,2,3,2,2)