Database Management Systems

© 2007 by Jerry Post
Database Exercises

Chapter 1 2 3 4 5 6 7 8 9 10 11 12

  1. Research and report on the steps needed to create a multi-language version of a form using Microsoft .NET (Web version). Or use Java if your instructor prefers.
  2. Review the documentation for the DBMS you are using and identify the features that it provides to support accessibility for all users.
  3. Review the documentation for the DBMS you are using and identify the main forms controls that it provides.

    4. For the following questions, create the databases and build the forms for the exercises from chapters 2 and 3.

  4. Review the documentation for the DBMS you are using and describe how reports can be accessed via the Web.
  5. Nurse schedule, Chapter 2, Exercise 1.
  6. Property tax assessor, Chapter 2, Exercise 2.
  7. Music store marketing, Chapter 2, Exercise 3.
  8. Translation service, Chapter 2, Exercise 4.
  9. Cleaning company, Chapter 2, Exercise 5.
  10. Club event, Chapter 2, Exercise 6.
  11. Network management, Chapter 2, Exercise 7.
  12. Health journal, Chapter 3, Exercise 1.
  13. Pipeline inspection, Chapter 3, Exercise 2.
  14. Distributor deliveries, Chapter 3, Exercise 3.
  15. Corporate flights, Chapter 3, Exercise 4.
  16. Corporate gift sales, Chapter 3, Exercise 5.
  17. Biology research, Chapter 3, Exercise 6.
  18. Farming system, Chapter 3, Exercise 7.

    19. Sally’s Pet Store

  19. Create forms to handle the administration of the merchandise inventory, including forms for Breed, Category, and Merchandise tables.
  20. Create a form to record orders of animals from suppliers.
  21. Create forms to record orders and receipt of merchandise from suppliers.
  22. Create a form to display a chart of merchandise sales by the main categories.
  23. Create a form that enables managers to select a starting and ending date and then display a chart showing total merchandise purchases over that time period for each supplier.
  24. Create a report that displays animal purchases by supplier. Include a chart that compares the total purchases from each supplier.
  25. Create a report that displays total (merchandise plus animal) sales by employee for the week. Include a chart showing the percentage of sales by each employee for the week.
  26. Create a report that displays total merchandise sales by Category by month.

    27. Rolling Thunder Bicycles

  27. Build a version of the Bicycle form that is based on simple master/detail subforms. Compare the result to the existing form. What are the strengths and weaknesses?
  28. Create a form to display a graph of bicycle sales (value and count) by model type for a specified time period. The time period should be entered as text boxes on the form, with a method to redraw the graph.
  29. Create a report that displays each state, the associated store within that state, and the total sales made with the help of that retail store. Include total sales by state.
  30. Create a report that displays sales of bicycles by model type by month. Include a chart that compares total sales by model type.
  31. Create a report that displays sales of bicycles by employee by year. Include charts for each year that compare the sales across employees.
  32. Create a report that charts the average length of time to build each bike model by month.
  33. Create a form that enables managers to select a component and generate a chart that shows the purchases and sales of that component over time.
  34. Managers want to see how the popularity of color schemes changes over time. Create a report that charts the number of bicycles painted in each color scheme by month. You might need a separate chart for each color scheme.

    35. Corner Med

  35. Add an object column to the Patient table to hold a photo. Add the Photo field to the Patient form. Run the form and add some stock photos of people.
  36. Create a report that prints a bill for a patient visit.
  37. Create a report that displays a list of all patient visits for the week by physician. Include a chart at the end to show the amount of revenue generated by each physician.
  38. Create a report that displays a chart for a specified patient. It should include all visits in chronological order and lists symptoms and treatments at each visit.
  39. Create a report that lists all insurance company billings and receipts by month..
  40. Create a report that lists the count of the number of patients by month under the primary ICD diagnosis categories. The major groupings are based on the following table.
    41. ICD9 CodeCategory
    001-1391. Infectious and Parasitic Diseases
    140-2392. Neoplasms
    240-2793. Endocrine, Nutritional, Metabolic Diseases, and Immunity Disorders
    280-2894. Diseases of the Blood and Blood-Forming Organs
    290-3195. Mental Disorders
    320-3896. Diseases of the Nervous System and Sense Organs
    390-4597. Diseases of the Circulatory System
    460-5198. Diseases of the Respiratory System
    520-5799. Diseases of the Digestive System
    580-62910. Diseases of the Genitourinary System
    630-67711. Complications of Pregnancy, Childbirth, and the Puerperium
    680-70912. Diseases of the Skin and Subcutaneous Tissue
    710-73913. Diseases of the Musculoskeletal System and Connective Tissue
    740-75914. Congenital Anomalies
    760-77915. Certain Conditions Originating in the Perinatal Period
    780-79916. Symptoms, Signs, and Ill-Defined Conditions
    800-99917. Injury and Poisoning
    V01-V85Supplementary Classification of Factors Influencing Health Status
    E800-E999Supplementary Classification of External Causes of Injury and Poisoning