Passing Lane is a small trucking company headquartered in Portland, Oregon. Pass
ID: 3715286 • Letter: P
Question
Passing Lane is a small trucking company headquartered in Portland, Oregon. Passing Lane’s information system consists of a file server and three workstations where freight clerks enter data, track shipments, and prepare freight bills. To perform their work, the clerks obtain data from the server and use database and spreadsheet programs stored on stand-alone PCs to process the data. At your meeting yesterday, Passing Lane’s president approved your recommendation to create a relational database to handle operations and provide links for the company’s shippers and customers.
- Since the firm is growing rapidly, what design features should be included in the new system to ensure it can grow with the company?
Explanation / Answer
The features which should be included in the new system to ensure that it can grow with the company are:
1. Inclusion of integrity constraints like primary key, foreign key to ensure no duplicate data is entered in the database and it is always accurate.
2. The tables should be in normalized form so that the data is grouped logically and has better performance.
3. There should be referential integrity to main consistent data in the database.
4. To enable fetching of data from more than one table at once, the referential integrity should be maintained so that a table can be linked to other table using it.