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:

Semantics

The study of meaning in language, focusing on the relationship between signifiers, like words, phrases, signs, and symbols, and what they stand for.

Syntax

A set of rules for arranging words and phrases to create well-formed sentences in a language.

Symbolic Structure

The use of symbols and signs in a systematic way to represent ideas or concepts in communication.

Underextension

Underextension is a language development error wherein a child uses a word too narrowly, applying it to a smaller range of objects or situations than is appropriate.