Introduction to Databases. Data vs. Information. Data – a collection of facts made up of text, numbers and dates: Murray 35000 7/18/86 Information - the meaning given to data in the way it is interpreted:
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Mr. Murray is a sales person whose annual salary is $35,000 and whose hire date is July 18, 1986.
Is to transform
Data driven decision making
Name: Barry Harris system?College: MedicineTel: 392-5555Basic Database Concepts
Name: Barry HarrisCollege: MedicineTel: 392-5555
Name: Barry Harris
To ensure that each record is unique in each table, we can set one field to be a Primary Key field.
A Primary Key is a field that that will contain no duplicates and no blank values.
A relational database is a collection of tables from which data can be accessed in many different ways without having to reorganize the database tables.
DON’T DUPLICATE DATA
Foreign Keys are keyslinkto data in other tables