week 4

In this assignment, you will create three queries by using SQL for your database (you can still add the attribute into your tables if you miss any one that is required in the queries):    

 Find the student names for all students who are in the BSIT program    

Find the faculty names for all faculty whose rank is associate professor    

Find the faculty names for all faculty who have taught CS251

 

 

weekFinal

In this assignment, you will use Microsoft Access to implement the database you have designed.

• Create/Complete Students, Faculty, and Classes tables in Access
• Add a few instances in each table
• Create/Complete the three queries you designed in Week 4
• Take screenshots for the tables and queries including the results
• Insert the screenshots into a Word document and add a short explanation for each screenshot
• Save your Word document as "yourname_WK5.docx"

SophiaPretty

(5)

Status NEW Posted 12 Dec 2017 08:12 AM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer