answersLogoWhite

0

AllQ&AStudy Guides
Best answer

SELECT*

from employees

This answer is:
Related answers

SELECT*

from employees

View page

no, you are refering to a fact table used to record activity over time. employee records should be in a dimension table, the fact table should have a foreign key to the employees table. The R in rdbms stands for relational. You want to understand the rules of normalization for oltp and denormalized star schema for olap.

View page

Yes. This is referred to as a self reference or circular relationshiop with just one Table. One classic example is an Employee table and some employees are managers and hence have child Employees.

View page

a good personnel has a sufficient knowledge of food preparation and service know the uses and function of food service tools and equipment has a good working relations with his\her employees and possesses management skills and has a knowledge on table etiquette and details in waiting on the table.

View page

Horizontal partitioning:

Horizontal partitioning is partitioning the table into no.of smaller tables on the basis of rows.

Eg:

In an employee table, employees with salary less than $10,000 will be partitioned into different table.

Vertical Partitioning:

Vertical parttioning is dividing the table based on the different columns.

Eg:

In the same employee table, retrieving oly the name and contact number of all the employees into a different table.

View page
Featured study guide

What is typically unique in each database table

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on

Locking a cell so that others cannot alter its contents is known as .

Shana is keeping track of the expenses as deductions for her business when she files paperwork at the end of the year. What is Shana working on

➡️
See all cards
No Reviews
More study guides
No Reviews

No Reviews
Search results