ais exam 3

warehouse

general accounting

production control

• planning and scheduling
• product design
• cost accoutning
• production operations

partnumber, description and # used of each component

sequense of steps, equipment used and duration of step

what, when and how much to produce based on ordes are forcasts

authorized tmanufacture of a specified quantity of a product

request for raw materials needed.

• byte
• field
• logical record
• file
• data base

design view of access

relations view of access

data sheet view of access

define fields, design view of access

input values in fields or add/delete/change records

sorting and pulling info from the database

• every colume is single-valued
• primary keys cant be null (blank)
• foreigh keys, if not null, correspond to a primary key in another table
• all nonkey attributes in table should describe a something about the primary key

file that contains the structure of the data base. relates all the schemas and map is stored as the data dictionary.

• system analysis
• conceptual design
• physical design
• implementation and conversion
• operation and maintenance

relationships between rea diagrams