Working by Microsoft Access designing a new database, the question here is what is the centre process of the database that you are trying to define? Access Database design is besides of an art than a science and common sense will prevail.
By alluring the time to identify the inner part process correctly, you will find that supplementary processes will plug in easily charge the structure of the system established and solid enough as time goes ~ the agency of and data volume increases. If you put some of Microsoft Access techniques including 'Database Normalisation' rules (up to the third norm) and deal with relationships (tables joins) and setting their keys & indexes, this moreover will determine the solid foundation to form on.
Scenario: Let's take every example process like a 'Sales Order Processing' database classification which has a list of international customers based in the UK, USA and/or Canada who broad way orders (eventually invoiced) for one or again food products (items) periodically (for a isolated order) and is dispatched by some independent distributor. The company is deemed a agency sized business and the sales team are answerable for processing their own orders. So, the earliest consideration will be the types of individual tasks required to fulfill this management; here are 6 examples:
A resource to enter customer information including collection name, address and contact details.
A urbanity to enter product information including issue name, price and stock inventory complaint.
The process to raise the instruct and assign quantity, price and ~ one special offers plus the need to apportion a freight company to distribute the commodities.
What types of reports will personnel stand in want of from a single order to purchaser lists and analysis?
Any management reports to have existence included on a monthly basis
The personnel accountable for running and maintaining the combination of parts to form a whole from raising the order, controlling house, running more sensitive reports to maintaining the database rule (administrator role).
This list should have ~ing more detailed and explicit from the examples overhead but it hopefully focuses your put in ~ to the type of database connected view required. This is an iterative procedure. That is before you start the converse engineering process itself (which is discussed in the step 2 of 7 division), you need to repeat the tasks required ~ dint of. looking again at each item and form sure nothing has changed in the design objectives.
No comments:
Post a Comment