Some databases
- R:Base first relational database for PC
- Microsoft Office Access
- Is it in the suite or for power users?
- Front end to SQL Server and Microsoft Azure SQL
- Works with VBA (Visual Basic for Applications)
- Is it in the UNCA labs?
- Is it part of Office 365
- Is it part of DreamSpark?
- LibreOffice and Apache OpenOffice base
Databases vs Spreadsheet
- Database of table vs Workbook of sheets
- More input validation and consistency constraints in databases
INDEX
function in Excel vs query by exampleINDEX
function in Excel vsWHERE
in SQL- Databases have forms
- Databases have reports
- Databases are less likely to be free
- Databases can be hard to learn
- Locals do call asking for Access experts
Trying out an example
This is based on the Social Network database in Stanford’s database course.
- Nice picture of relations
- Data in HTML
- Data in SQL schema
- Data in Open Document Format