Exercise Instructions 1. Use the SQL Server Management Studio to complete this lab. a. Create a SQL script file named Car_Inspection_DB_Script_Your_initi als. SQL (John Doe would name it Car_Inspeciton_DB_Script_JD. SQL). When executed this script is to create a database named Car_Inspection_Your_Initials that contains the objects described in this document. 2. Upload and submit the Car_Inspection_DB_Script_Your_Initi als. SQL file before the due date. Car_Inspection_Your_Initials Design Specifications

Solution: the categorization of functional and non-functional requirement are as follows: some of the more typical functional requirements include: • business rules• transaction corrections, adjustments and cancellations• administrative functions• authentication• authorization levels• audit tracking• external interfaces• certification requirements• reporting requirements• historical data• legal or regulatory requirementswhile,some typical non-functional requirements are: • performance – for example response time, throughput, utilization, static volumetric• scalability• capacity• availability• reliability• recoverability• maintainability• serviceability• security• regulatory• manageability• environmental• data integrity• usability• interoperability