There are three ways to add data to database management systems
- Enter the data directly
- Enter the data into another program (e.g., a spreadsheet) and import it
- Get the data from somewhere and import it (though as well learn in 2 weeks, the data isn’t always ready to import into a database)
Demo:
- Entering data directly into SQLite
- Create weather table: RecordID(pk), JulianDay, Temp, Notes
- Enter some data
- Entering data directly in Access
- Importing data into SQLite
- Walk through of survey table import from homework