• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  57. 57
    57
  58. 58
    58
  59. 59
    59
  60. 60
    60

The dental surgery - This assignment calls for a database solution to a relatively simple scenario, however before even opening Access I must properly design my solution on paper.

Extracts from this document...

Introduction

TABLE OF CONTENTS TABLE OF CONTENTS 1 INTRODUCTION 2 THE DENTAL SURGERY 3 LIST THE ENTITY TYPES 3 LIST THE ATTRIBUTES FOR EACH ENTITY INDICATING ANY PRIMARY KEYS CLEARLY 3 NORMALISE THE DATA 4 WRITE THE RELATIONS IN TABLE TYPE FORM 5 BRIEFLY DESCRIBE ONE ALTERNATIVE NORMALISATION TECHNIQUE 6 CREATION OF TABLES 9 POPULATION OF TABLES 28 RELATIONSHIPS 30 CREATION OF QUERIES 31 CREATION OF FORMS 51 CREATION OF REPORTS 53 USER REQUIREMENTS 57 COMPARE YOUR SOLUTION WITH THE ENTERPRISE RULES. 59 TESTING OF DATABASE 59 CONCLUSION 60 Introduction This assignment calls for a database solution to a relatively simple scenario, however before even opening Access I must properly design my solution on paper. This will involve identifying all possible entities and their related attributes. Once they have been established I must identify any primary keys and attempt to normalise the tables to ensure I have minimum duplication and no redundant data. At this stage I will produce an Entity Relationship diagram and the design should be finished. Although I have never used access before I hope to be able to implement a working database and hopefully learn a lot while doing so. From what I have seen so far, the wizard tools seem to do quite a lot for you so my main task will be to create the tables and set their relationships correctly. ...read more.

Middle

To reflect these relationships in access we must go to the relationships section, add all tables and drag the primary key from each table into the corresponding key on the Appointment table. When doing this, the following text box will appear: Make sure that the Enforce referential integrity box is ticked and click on Create. Once this has been carried out for all relevant tables and attributes, the relationships will look like this: Creation of Queries QUERY 10: List the patients and their treatments by a particular surgeon. Tables Required: Appointment Patient Treatment Fields Required: Appointment SID Patient PID Pfname Psname Treatment TID Tname Tdesc As this query calls for information relating to a particular Surgeon, we need to enter the SID for the query to run properly, however this must be set as a Parameter so that each time the query is run you are prompted for the surgeon ID. To do this, simply add the text "Enter Surgeon ID" within [] in the criteria field. When the query is executed, the following box will appear: Simply enter the required Surgeon ID and click on OK. If, for example, we run the query for Surgeon ID 4 the following output is produced: SQL View of Query SELECT TBL_Appointment.SID, TBL_Patient.PID, TBL_Patient.Pfname, TBL_Patient.Psname, TBL_Treatment.TID, TBL_Treatment.Tname, TBL_Treatment.Tdesc FROM TBL_Treatment INNER JOIN (TBL_Patient INNER JOIN TBL_Appointment ON TBL_Patient.PID = TBL_Appointment.PID) ...read more.

Conclusion

The creation of Tables is relatively straightforward, however this is where I encountered my most significant problem. While setting the properties for the auto number fields in the Patient, Surgeon and Treatment tables I assumed that they should all be 'Indexed' as "Yes (No Duplicates)". This was fine until I created the Appointment table in the same fashion and tried to set the relationships. Its obvious now that I had to set the properties in the Appointments table to allow duplicates as the PID, SID and TID fields are basically a copy of the Auto number fields in the other tables and therefore 'Duplicates'. The queries, forms and reports in my database where all created using the access wizard and default styles. These are perfectly acceptable and the wizard is a wonderful tool for undertaking this task quickly but this is where I would make improvements if I where doing this again or creating another database of my own. Specifically in the design and layout of text boxes etc. Other improvements would include adding more queries and reports relevant to the users specific requirements. In summary I believe I have created a sound working solution to the problem laid out in the assignment and all enterprise rules have been adhered to within the database. Data Analysis and Database Design Perform Data modelling, design implement and use small databases Page: 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Healthcare section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work