Course Logistics PDF

Course Logistics Why SQL? Why MySQL? Response Both are industry standard You gain competency in one flavor of SQL with MySQL Additional rationale: MySQL is free => no worries about fees Learn at our own pace; ok to make mistakes Vanderbilt Honor System All academic work done...

Course Logistics Why SQL? Why MySQL? Response Both are industry standard You gain competency in one flavor of SQL with MySQL Additional rationale: MySQL is free => no worries about fees Learn at our own pace; ok to make mistakes Vanderbilt Honor System All academic work done is governed by the Vanderbilt Honor Code System. Read and understand the course's Academic Honesty Policy from the syllabus. Do not share and copy work in any form with any student or website (past, present, future). Minimum penalty is an “F” in the course. The Honor council will prosecute any reported incidences. Use of AI tools is restricted. For any individual work, the work must be your own, i.e., No copying, No collaboration, etc When working in group, ensure that you work as a team and work with dedication; I should not hear complaints that only one person is putting all the effort Your final reports should discuss how you split the work Hardware/Software See Syllabus for laptop configuration requirements Mac/Windows Mac chip – Intel/Apple Have enough space in your laptop throughout the semester 15-20 GB Install DB related software – Wait for instructions WAMP/MAMP MySQLWorkbench What is a database? Collection of related data used for a specific purpose Examples of databases Accounts database Payroll database Students database Amazon products database Airline reservation database What is a DBMS? A software package to implement and maintain databases In other words, a program that allows us to efficiently manage a large database and allows it to persist over long periods of time. Examples DB2 (IBM) SQL Server ( Microsoft) Oracle MySQL PostgreSQL Client/Server System Relational Data model A database is an organized collection of structured information, or data, typically stored electronically in a computer system. Database is collection of relations (tables). Relational Data model A relation is a set of tuples. Each tuple can have many attributes. Relation is a table with rows and columns In SQL we refer relation as table. Tuples à Rows Attributes à Columns Relation Example: A relation of auto parts supplier schema Supplier (Supplier-number:integer, Supplier-name:string) instance Supplier-number Supplier-name 1 ABC ltd 2 XYZ corp Hans Rosling Exercise http://www.youtube.com/watch?v=jbkSRLYSojo Hans Rosling Exercise 1. Dr. Rosling concludes that the analysis involved plotting “120,000 numbers.” Explain where the 120,000 count came from. 2. List the attributes that you believe must be stored in a database that supports this analysis (and perhaps similar analyses). 3. Give candidate (tentative) relational schema (at least two) for a database that would support this and similar analyses. (Relational schema can have multiple tables (schema).