Answered step by step
Verified Expert Solution
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, companycity Employees employee name, employeeage, employeestreet, employeecity Works employee name, companyname, employeesalary Manages employee name, managername The queries performed on the above tables and the query frequencies: Insert a new company year Insert a new employee and assign the employee to work for a company month Insert a manager for an employee day Find the names of all companies located in a particular city day Find the names and ages of all employees whose salaries are between a particular amount of dollars and a particular amount of dollars day Using the scenario described above, which of the following is the most appropriate storage structure for the table Employees?
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, companycity
Employees employee name, employeeage, employeestreet, employeecity
Works employee name, companyname, employeesalary
Manages employee name, managername
The queries performed on the above tables and the query frequencies:
Insert a new company year
Insert a new employee and assign the employee to work for a company month
Insert a manager for an employee day
Find the names of all companies located in a particular city day
Find the names and ages of all employees whose salaries are between a particular amount of dollars and a particular amount of dollars day
Using the scenario described above, which of the following is the most appropriate storage structure for the table Employees?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started