databasedesignbasics_11.pdf - Good Database Design Training...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Good Database Design Training Session Handout Page 1 Most topics came directly from Microsoft Access Help. Database Design Basics Table of Contents SOME DATABASE TERMS TO KNOW ........................................................................................................ 1 WHAT IS GOOD DATABASE DESIGN? ....................................................................................................... 2 THE DESIGN PROCESS ................................................................................................................................... 2 D ETERMINING THE PURPOSE OF YOUR DATABASE ............................................................................................. 3 F INDING AND ORGANIZING THE REQUIRED INFORMATION ................................................................................. 3 D IVIDING THE INFORMATION INTO TABLES ........................................................................................................ 4 T URNING INFORMATION ITEMS INTO COLUMNS ................................................................................................. 5 S PECIFYING PRIMARY KEYS ................................................................................................................................ 6 C REATING THE TABLE RELATIONSHIPS ............................................................................................................... 6 Creating a one-to-many relationship ............................................................................................................. 6 Creating a many-to-many relationship .......................................................................................................... 7 Creating a one-to-one relationship ................................................................................................................ 7 R EFINING THE DESIGN ........................................................................................................................................ 8 R EFINING A TABLE .............................................................................................................................................. 9 A PPLYING THE NORMALIZATION RULES ........................................................................................................... 10 First normal form ......................................................................................................................................... 10 Second normal form ..................................................................................................................................... 10 Third normal form ........................................................................................................................................ 10 A properly designed database provides you with access to up-to-date, accurate information. Because a correct design is essential to achieving your goals in working with a database, investing the time required to learn the principles of good design makes sense. In the end, you are much more likely to end up with a database that meets your needs and can easily accommodate change. Some database terms to know Microsoft Office Access 2007 organizes your information into tables : lists of rows and columns reminiscent of an accountant’s pad or a Microsoft Office Excel 2007 worksheet. In a simple database, you might have only one table. For most databases you will need more than one. For example, you might have a table that stores information about products, another table that stores information about orders, and another table with information about customers. Each row is called a record , and each column is called a field . A record is a meaningful and consistent way to combine information about something. A field is a single item of information an item type that appears in every record. In the Products table, for instance, each row or record would hold information about one product. Each column or field holds some type of information about that product, such as its name or price.
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Good Database Design Training Session Handout Page 2 Most topics came directly from Microsoft Access Help. What is good database design? Certain principles guide the database design process. The first principle is that duplicate information (also called redundant data) is bad, because it wastes space and increases the likelihood of errors and inconsistencies. The second principle is that the correctness and completeness of information is important. If your database contains incorrect information, any reports that pull information from the database will also contain incorrect information. As a result, any decisions you make that are based on those reports will then be misinformed.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern