Question: Database and Project Management Module 3: Creating Queries Assignment 2 PART 1 Using the database, you created for Module 2, add/modify or edit the following
Database and Project Management Module 3: Creating Queries Assignment 2 PART 1 Using the database, you created for Module 2, add/modify or edit the following information: 1. Order the Staff and Client Table alphabetically. 2. Create a Category Table CategoryID Category Tip A Adoption Assign CategoryID as Primary Key D Divorce EP Estate Planning G Guardianship PA Prenuptial Agreements AN Annulments S Separation Agreements 3. Create Rates Table RateID Rate Tip 1 $200 Assign RateID as Primary Key 2 $250 3 $300 4 $350 5 $400 4. Create Billing Table For the Hours Field use Field Type Number. Field Size Double. Decimal Places 2 BillingID ClientID BillingDate Category ID Hours RateID StaffID Tip AutoNumber 3 08/01/2018 A 1.0 3 1 Assi
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
