Question

database access

im asked to create two tables; one called employees and one called products.

im then asked to enter the info in the picture below into the products table.

im then asked to create queries and im not quite sure how to do some

of them. any help would be appreciated

SerialNo Manufacturer 242XG1 Micron 242XG2 Micron 295XT4 Micron 295XT5 Micron 295XT6 Micron 295XT7 Micron 300RZ2 Micron 300RZ3 Micron 300RZ4 Micron 388MQS1 Compaq 388MQS2 Compaq 388MQS3 Compaq 388MQS4 Compaq 4848XHI Micron 4848XH2 Micron 4848XH3 Micron 4848XH4 Micron 4848XH5 Micron 511984CDE1 Lexmark 511984CDE2 Lexmark 72JRVI Compaq 72JRV2 Compaq 72JRV3 Compaq Description Transtrek 3000 Transtrek 3000 Prosignet303 Prosignet 303 Prosignet 303 Prosignet303 Prosignet303 Prosignet303 Prosignet303 Centuria8088 Centuria8088 Centuria8088 Centuria8088 Transtrek 3000 Transtrek 3000 Transtrek 3000 Transtrek 3000 Transtrek 3000 Optra2000 Optra2000 Deskpro99 Deskpro99 Deskpro99 Purchase Date InitialValue EmployeePrice 7/1/1998 $2,000.00 $1,000.00 7/1/1998 $2,000.00 $1,000.00 7/15/1998 $1,800.00 $900,00 7/15/1998 $1,800.00 $900.00 7/15/1998 $1,800.00 $900.00 7/15/1999 $1,800.00 $900.00 8/1/1999 $1,700.00 $850.00 8/1/1999 $1,700.00 $850,00 8/1/1999 $1,700.00 $850.00 6/1/1999 $1,500,00 $750,00 6/1/1999 $1,500.00 $750,00 6/1/1999 $1,500.00 $750.00 6/1/2000 $1,500.00 $750.00 7/15/2000 $1,900,00 $950.00 7/15/2000 $1,900,00 $950.00 8/1/2000 $1,900.00 $900,00 8/1/2000 $1,800.00 $900,00 8/15/2000 $1,800,00 $875.00 1/5/2001 $1,750,00 $1,000.00 1/5/2001 $2,000,00 $1,000,00 4/1/2001 $2,000.00 $1,000,00 4/1/2001 $2,000.00 $1,000.00 4/1/2001 $2,000,00 $1,000.00

Answer 1

select employeeName, salary,startDate from employees where salary < 25000


select * from products where PurchaseDate BETWEEN #7/1/1999# and #7/31/1999#

select SerialNo, Manufacturer, Description, InitialValue from products where Manufacturer = 'Compaq' order by SerialNo 

select * from products where SerialNumber LIKE '5%'

select * from employees where lastName = '<your name>'

Please do note that the database is assumed as a sql database and hence written the queries in sql.
Kindly let me know if there are any issues with the date format or any other queries, Thank you :)