Question: Create a Database Design after the System Design Models and create the following database tables into the document as MS Word tables A) Client Information

Create a 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!