![]() ![]() PySimpleGUI: We are going to use PySimpleGUI to design user interfaces for the project. # Just be sure any changes have been committed or they will be lost. ![]() # We can also close the connection if we are done with it. Example usage: import sqlite3Ĭ.execute('''CREATE TABLE stocks (date text, trans text, symbol text, qty real, price real)''')Ĭ.execute("INSERT INTO stocks VALUES ('','BUY','RHAT',100,35.14)") sqlite3 is bundled with Python versions after 2.5, so you do not need to install it manually. Sqlite3: We will use sqlite3 library to connect to our SQLite database in Python to execute queries. You can download SQLiteStudio from the following website: We will use SQLiteStudio to create our database files including all the tables, attributes and relationships in between attributes. SQLite Studio: SQLiteStudio is a desktop application for browsing and editing SQLite database files. You may download the desktop version on: Online version of Draw.IO is available on: (Please note that this is an external link, and we are not responsible for the online status of the slides, so the best practice would be to have a local copy of all slides in case the external server is not accessible.)ĭraw.IO: We are going to use Draw.IO to design the E/R Diagram of the project. Concurrency Control (Ch.17) Textbook and Software 1 Overview of Transaction Management (Ch.16)ġ4. Overview of Storage and Indexing (Ch.8)ġ3. Schema Refinement and Normal Forms (Ch.19)ġ0. ![]() Schema Refinement and Normal Forms (Ch.19)ĩ. In case of a change in the dates, it will be informed with an email. Midterm: 9 April 2023, Sunday, 20.00 – 23.00 EB Building (Rectorate)Īrçin Ülkü Ergüzen ( hours: Monday 10:30, Tuesday 12:30 ( Online) (Please send an email first.) (Private Zoom address information is available in Syllabus) Classes CS 281 – Computers and Data Organization Bilkent University, Spring 2022-2023 InstructorĪll Sections: Semra Güleç ( hours: Wednesday 12:30, Friday 12:30 (EA-504) ![]()
0 Comments
Leave a Reply. |