Seacrest Bedding Is Changing from a File-Oriented System to a Relational

question 86

Essay

Seacrest Bedding is changing from a file-oriented system to a relational database system.Identify and design at least three tables that would be needed to capture data for a sales transaction.Each table should include a primary key,three non-key attributes,and foreign keys as necessary.Make up data values for two records within each table.

---

Definitions:

Human Capital

The value of an individual’s competencies and capabilities, which is considered an asset to an organization’s performance and efficiency.

Human Resources Management

The strategic approach to the effective and efficient management of people in an organization to help their business gain a competitive advantage.

Personnel Department

The division within an organization tasked with managing employee-related functions, including recruitment, training, and benefits administration.

Roosevelt Corollary

An extension of the Monroe Doctrine articulated by President Theodore Roosevelt in 1904, asserting the right of the United States to intervene in Latin America to stabilize the economic affairs of countries if they were unable to pay their international debts.