In reference to creating a software engineering system design document for a medical office:

PART A 1. Create a new section titled Database Design after the System Design Models and create the following database tables into the document as MS Word tables A) Client Information (Include Name, Address, etc) B) Exam or Procedure (details including date, ICD-9, Memo, etc) C) IDC-9 Table (this table should have just the ICD-9 and Description fields and not specific data) D) Other tables used for combo boxes, dropdowns, and lookups Make sure you adhere to the following:

Exercise best practices when naming the tables and fields

Define all data types

You do not need to have data but just the table structure

Your tables for the database should look something like this:

Field Name	Type	Length
Firstname	String	25
LastName	String	40
Address1	String	40

PART B 1. Add a new section titled Graphical User Interface after the Database Design section 2. Create all user interfaces. You should have at minimum the following user interfaces: A) New Client Entry B) Existing Client Search C) Client Data Display D) Detailed Exam or Procedure Entry You can use any tool to design the Graphical User Interfaces for this system.