ERD, Entity Relationship Diagram, Inputs, details of all the data to be stored in each table of your database, Processes, what needs to be done to generate the outputs (e.g. queries), Output, what we want the system to produce (e.g. reports), Entity Relationship Diagram, Shows the designer what tables there are in a database system, and how they are related (linked), One-to-one, where a record in one entity (table) is associated with exactly one record in another entity (table),, One-to-many, one record in a table can be linked to many records in another table, Data Dictionary, contains details relating to the structure of all of the data held in the various tables of a database, Wireframe, an outline or diagram of a form or report interface, Form, used to input information in a databse, Report, used to present output from a databse, Queries, used to search and extract specific information from a databsae, Navigation structure diagrams, used in the design stage to provide an overview of how the entire system will link together, End User, the person(s) who will use the system once built, End user requirements, A list of what the end user wants the system to look like and be able to do.

Database Design elements

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

)
Continue editing: ?