Create a structured database through the use of relational concepts Implement basic processing functionalities to create new structured database environments
Step One Scenario
You are working as a database administrator for Quantigration, a networking equipment manufacturer. The company has grown quickly and is still evolving its internal business processes to handle the rapid growth. Customer return merchandise authorizations (RMAs), used to track shipments for defective or incorrect parts, are a specific area that has been identified as problematic.
Your supervisor at Quantigration has asked you, as part of their development team, to create a database for a new software application that will be used for processing RMAs. Because there are several locations where merchandise can be taken in, the application will also need to record where items are received. This system will also capture where the equipment is going next—repair, scrap, or refurbishing and resale. The warehouse shipping and receiving employees at your company will be the people using this application and are considered your "end users" for the application. Part of their job is to process customer return shipments. This involves the following:
Assessing the quality of the items being returned for defects
Identifying missing parts
Identifying signs of obvious wear and tear (such as dents or scratches to the equipment)
Step One Directions
Create a Database