Database Design P1, M1 & D1
Assignment 1
Database design
Database is a place to store lots of data, imagine it as a giant virtual filling cabinet that can be organized in many ways. There’s software called (DBMS) which stands for database management system which allows the user to manage data in database such as; create, delete or update.
Entities
Entities are objects with significant mass and purpose, in database entities are tables. Every table contains many fields/attributes. The user must create a table before inputting any data. When creating a table you need to define a few things, data type, fields name & a description.
Fields Name
This is a column heading, this will display the title for the column etc first name, last name, address.
Data Type
This is the content of the data & the data type decides what content can be inputted & the file size.
Description
This is used to explain the content & shows a list of ‘limitations’ the user can change to get a more accurate reading etc. input mask.
Attributes
A characteristic, for example; a field has many attributes such as data like numbers or letters. Attributes can be used as a synonym for a “field”. In DOS systems, each files has an attribute, each file has many properties that shows if the file is “read only”, visible or encrypted.
Queries
A query is use for searching some specific record. It allow user to set conditions and then search the record which match the conditions. User also is able to make the search mix up with other table and sort the order of the result.
Reports
A Report is a summary of record. Everything you plain to print should put inside. Its purpose is for user to view information quickly and easily so display the result simply and efficiently is the main point.
Forms
Form is used for collect and edits information and transfers them to table. It is similar to application forms that allow user to fill in or delete their data easily and it also able to let user design
Database design
Database is a place to store lots of data, imagine it as a giant virtual filling cabinet that can be organized in many ways. There’s software called (DBMS) which stands for database management system which allows the user to manage data in database such as; create, delete or update.
Entities
Entities are objects with significant mass and purpose, in database entities are tables. Every table contains many fields/attributes. The user must create a table before inputting any data. When creating a table you need to define a few things, data type, fields name & a description.
Fields Name
This is a column heading, this will display the title for the column etc first name, last name, address.
Data Type
This is the content of the data & the data type decides what content can be inputted & the file size.
Description
This is used to explain the content & shows a list of ‘limitations’ the user can change to get a more accurate reading etc. input mask.
Attributes
A characteristic, for example; a field has many attributes such as data like numbers or letters. Attributes can be used as a synonym for a “field”. In DOS systems, each files has an attribute, each file has many properties that shows if the file is “read only”, visible or encrypted.
Queries
A query is use for searching some specific record. It allow user to set conditions and then search the record which match the conditions. User also is able to make the search mix up with other table and sort the order of the result.
Reports
A Report is a summary of record. Everything you plain to print should put inside. Its purpose is for user to view information quickly and easily so display the result simply and efficiently is the main point.
Forms
Form is used for collect and edits information and transfers them to table. It is similar to application forms that allow user to fill in or delete their data easily and it also able to let user design