· User View 1: For each administrative building, list its name and number and it

Question

·       User View 1: For each administrative building, list its name and number and its building manager.

·       User View 2: For each classroom building, list its name and number, type (i.e., science or humanities), and its location.

Once the information-level design is completed:

·       Create the tables in the cumulative design using Access. Enter sample information into the tables. Each table should have at least five records.

·       Create the following queries, and save them with names that describe their function:

a.       All science buildings

b.       All building administrators with the last name Smith

Explanation / Answer

create table administrativeBuilding(name varchar(100), number Int ,manager varchar(100));
insert into administrativeBuilding(name, number, manager) values("administrativeBuilding 1", 1,"SMITH");
insert into administrativeBuilding(name, number, manager) values("administrativeBuilding 2", 2,"SMITH 2");
insert into administrativeBuilding(name, number, manager) values("administrativeBuilding 3", 3,"manager 3");
insert into administrativeBuilding(name, number, manager) values("administrativeBuilding 4", 4,"SMITH");
insert into administrativeBuilding(name, number, manager) values("administrativeBuilding 5", 5,"manager 5");
select * from administrativeBuilding where manager = "SMITH";
-- Your code here!

create table classRoomBuilding(name varchar(100), number Int ,type varchar(100));
insert into classRoomBuilding(name, number, type) values("classRoomBuilding 1", 1,"Science");
insert into classRoomBuilding(name, number, type) values("classRoomBuilding 2", 2,"Humnities");
insert into classRoomBuilding(name, number, type) values("classRoomBuilding 3", 3,"Science");
insert into classRoomBuilding(name, number, type) values("classRoomBuilding 4", 4,"Humnities");
insert into classRoomBuilding(name, number, type) values("classRoomBuilding 5", 5,"Science");
select * from classRoomBuilding where type= "Science"

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.