Create the database for continental palms hardware company

Reference no: EM132286556

Data and Information Management Assignment -

1. Create the database for Continental Palms Hardware Company (CPHC) in Oracle. Enforce as many integrity constraints as you can.

2. Enter the attached sample data into the database.

3. Answer the following queries in Oracle SQL. Include all SQL statements in script file. The statements must be tested. Sample results are available on the G: drive.

Get the ID, first name, last name, and birthdate of every employee of CPHC.
Get the ID, name (first name plus last name), and age of every female employee of CPHC.
Get the ID, name, and age of every female salesperson.
Get the ID, name, and age of every female salesperson who sells some products manufactured by Stanley.
Get the following about every female salesperson who sells some products manufactured by Stanley: ID, name, age, and products (UPC and manufacturer) authorized to sell. Include products not manufactured by Stanley too.
Get the following about every female salesperson who sells some products manufactured by Stanley: ID, name, age, number of products authorized to sell, and number of manufacturers of these products.
Get the following about every female salesperson who sells products from multiple manufactures or more than five products: ID, name, age, number of products authorized to sell, and number of manufacturers of these products.
Get the following about every female salesperson who sells products from multiple manufactures or more than five products, but does not sell any product by Stanley: ID, name, age, number of products authorized to sell, and number of manufacturers of these products.
Get the ID, name, age, and manager name (if any) of every female salesperson.
Get the ID, name and age of every female salesperson who sells all of the products manufactured by Stanley. (Hint: This query involves the Division operation in relational algebra, but is notoriously difficult to write in SQL. Consider using sub-queries. Restate the query as "Find every female salesperson, such that there does NOT exist any product manufactured by Staley that the salesperson does NOT sell").

Note - Just need the answers of question number 3, in which only needed 10 SQL queries. No data loading and database is required.

Attachment:- Assignment File.rar

Reference no: EM132286556

Questions Cloud

Teams can work great or they can be a disaster : Teams can work GREAT or they can be a disaster. One aspect of team dynamics, team COHESIVENESS (aka COHESION) can contribute to high team performance.

Why is it important for managers to learn : Why is it important for managers to learn how to DELEGATE when it comes to decision making?

Finds a vulnerability in one of its products : If a hardware or software maker finds a vulnerability in one of its products, how should it respond? Does it have a legal responsibility to warn its users?

Group of italian expatriates gathers : This case emphasizes Italian society and its institutions and why young Italians are more likely to leave the country to seek fortunes abroad.

Create the database for continental palms hardware company : Create the database for Continental Palms Hardware Company (CPHC) in Oracle. Enforce as many integrity constraints as you can

Which controlling techniques would you use to measure : Which controlling techniques would you use to measure performance? describe the controlling approaches you would use as a manager.

How does employee engagement relate to productivity : How does employee engagement relate to productivity? Your response should reflect your interpretation and critical thinking based on your personal experiences.

Which step of the quantitative analysis approach : Sensitivity analysis is most often associated with which step of the quantitative analysis approach

How you can use linkedin to professional advantage : Create a Professional Social Media Presence - Here are some ideas about how you can use LinkedIn to professional advantage

User Account

All Pages