Manufacturing System Database and VBA Review

Flashcards covering database architecture, normalization, and VBA programming concepts for a manufacturing management system.

Database Normalization

The process of organizing a database to reduce redundancy, improve consistency, avoid errors, and make maintenance easier.

Primary Key

An attribute that uniquely identifies each record in a table, ensuring every row is distinguishable from all others.

Foreign Key

An attribute used to connect two tables; it is the primary key in one table but acts as a link in another table to create relationships.

First Normal Form (1NF)

A rule stating that every field must contain only one value (atomic values) and there must be no repeating groups.

Second Normal Form (2NF)

A rule stating the table must satisfy 1NF and all non-key attributes must depend on the entire primary key.

Third Normal Form (3NF)

A rule stating the table must satisfy 2NF and non-key attributes must not depend on other non-key attributes, avoiding transitive dependencies.

Products Good Link

An intermediate table used to manage many-to-many relationships by defining which raw materials are required to manufacture each product.

Sales Order

An order type where products are sold to customers, resulting in a decrease in product stock.

Purchase Order

An order type where raw materials are bought from suppliers, resulting in an increase in raw material stock.

Production Order

An order type that transforms raw materials into finished products, decreasing raw material stock and increasing finished product stock.

Contribution Margin

A measure of profitability calculated using manufacturing costs and sales data to support managerial decision-making.

Manufacturing Cost Formula

$$\text{material quantity} \times \text{Purchase cost}$$

Sub (VBA)

A macro or procedure that performs an action but does not return a value directly.

Function (VBA)

A block of reusable logic that performs a calculation and returns a specific value.

Dim (VBA)

A statement used to declare variables, which act as temporary storage boxes for information while code runs.

InputBox

A VBA function that opens a dialog box to collect information from the user without them typing directly into the database.

MsgBox

A VBA function used to provide feedback to the user, such as confirming successful actions or explaining errors.

Application.Match

A VBA method used to search for a specific value (like a primary key) within a range and return the corresponding row number.

If IsError

A validation check used in VBA to determine if a search (like Application.Match) failed to find a valid ID before the code proceeds.

Cells(row, column)

A VBA property used to read from or write data to specific cells dynamically within a worksheet.

For Loops

A programming structure that repeats code to go through many rows, useful for calculating totals or updating costs across multiple records.

Atomic Values

The principle in 1NF that every field should contain a single, indivisible piece of information.

Transitive Dependency

A situation where a non-key attribute depends on another non-key attribute, which must be removed to satisfy 3NF.

Navigation Sheet

The front page of the system containing buttons to improve usability, learnability, and efficiency for the user.

CustomerID

The primary key for the customer table, chosen because names are not unique and using a unique ID improves data integrity.