DBMS Laboratory Exercise 7- week 10

Database Management Systems I Laboratory Exercise 7- week 10Joins Try out the following queries and write down what each query generatesselect name from sys.databases use DBMSI select * from sys.tablesselect * from sys.databases select * from INFORMATION_SCHEMA.COLUMNS  Use DBMS1 database and answer the following questions. Make a list of customer names and the respective states they live in. Display the stock details with the corresponding manufacture’s name. Prepare a list of manufacturers that supply kickboards. Find...

Read More

download DBMS practical 6 answers for the dbms1 practical 6 --Q1 create table Student( sno varchar(30) primary key, stName varchar(30), address varchar(30), phone int, course varchar(30) ); --Q2 insert into Student values('ST001','Nilusha','Galle',0992333333,'IT') insert into Student values('ST002','Shan','Colombo',0112345345,'IT') insert into Student values('ST003','Janani','Kandy',0812222222,'IS') --Q4 select * from Student --Q5 alter table Student add age int --Q6 alter table Student add last_name varchar(30) update Student set last_name='Perera' where...

Read More