![]() ![]() Also, avoid placing the same data point in more than one table, which adds unnecessary complexity. For instance, consider separating the street address from the country so that you can later filter individuals by their country of residence. Be sure to break down the information into the smallest useful pieces. This information will later become part of the data dictionary, which outlines the tables and fields within the database. Then list the types of data you want to store and the entities, or people, things, locations, and events, that those data describe, like this: Start by gathering any existing data that will be included in the database. Comb through any existing data systems (including physical and digital files).Analyze business forms, such as invoices, timesheets, surveys.Here are some ways to gather information before creating the database: For instance, if you were making a database for a public library, you’d want to consider the ways in which both patrons and librarians would need to access the data. ![]() Make sure you consider the database from every perspective. Understanding the purpose of your database will inform your choices throughout the design process. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |