Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the following relational database tables, queries and query frequencies: The database tables ( assume these tables were created without any foreign key constraint )

Given the following relational database tables, queries and query frequencies:
The database tables (assume these tables were created without any foreign key constraint):
Companies (company name, company_city)
Employees (employee name, employee_age, employee_street, employee_city)
Works (employee name, company_name, employee_salary)
Manages (employee name, manager_name)
The queries performed on the above tables and the query frequencies:
Insert a new company (10/year)
Insert a new employee and assign the employee to work for a company (10/month)
Insert a manager for an employee (10/day)
Find the names of all companies located in a particular city (100/day)
Find the names and ages of all employees whose salaries are between a particular amount of x dollars and a particular amount of Y dollars (200/day)
Using the scenario described above, which of the following is the most appropriate storage structure for the table Employees?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions