Question 1 use the attached database to provide the

Assignment Help C/C++ Programming

Reference no: EM13380158

Question 1: Use the attached database to provide the relational algebra which would list the requested information (showing the result relation for EACH STEP). (6 marks each - total 48 marks)

a. Give the details of all suppliers in the Sault Ste Marie.

b. List all inventory items with a quantity less than 100 units

c. List all the inventory items stored in Sudbury

d. Give the supplier details (name and id) for those located in Sudbury.

e. List all the supplier names who supply all the red parts.

f. List the details of parts supplied by Quality

g. List the part number of all parts supplied and located in the same city.

h. List the supplier details for suppliers who do not supply blue parts.

Reference no: EM13380158

Questions Cloud

1distinguish between the terms lsquoerp implementation and : 1.distinguish between the terms lsquoerp implementation and lsquoerp configuration2.explain the purpose of the entity

Introductionthis is an individual assignment in which you : introductionthis is an individual assignment in which you can explore the use of extensible files in web programming

The purpose of this assignment is to provide you with : the purpose of this assignment is to provide you with experience in some basic tasks of a systems analyst. this is

1 your experiences with the social networking sites like : 1. your experiences with the social networking sites like craig list etc etc?2. include how long you have been using

Question 1 use the attached database to provide the : question 1 use the attached database to provide the relational algebra which would list the requested information

Consider the following schema of an online flight : consider the following schema of an online flight reservation agency.customercid lastname firstname dobflightfid

1 what is the output of the following c programsnbspinclude : 1. what is the output of the following c programs?nbspinclude ltiostreamgtusing namespace stdint mainnbspnbspnbsp cout

1a describe the high level steps involved for decryption : 1.a describe the high level steps involved for decryption using a feistel cipher.b modify the pseudo code provided in

Have to write a small program that prompts the user to : have to write a small program that prompts the user to enter a temperature in degrees fahrenheit and then prints a

User Account

All Pages