Try  HackMD Logo HackMD

第七次會議

後端

期中簡報

  • 試講
  • 要修改的部分

phase 3

  • Show the implementation of tables in target DBMS (snapshots of tables in DBMS)
  • SQL statements for database construction and data population
  • Estimate the number of database operations for each table in the operational scenarios (provide the estimated usage frequency of each table through SQL per day) (optional)
  • Estimate the size of each table (in terms of KBytes or MBytes) which is (the length of the table schema * the average number of tuples in the table) (optional)
  • Implementation and demonstration of the database system (partial) (snapshots of GUI)
  • 範例
  • due on 12/8
Last changed by 
 
資料庫系統
0
110

Read more

Untitled

May 29, 2023
第九次會議

後端組 Docker 使用 Python 套件管理太麻煩，捨棄 env https://fastapi.tiangolo.com/deployment/docker/ 為了 import 其他檔案，使用以下寫法 from app import [檔案名稱]

Dec 18, 2022
4.4 SQL Statements Used to Insert the data - data population

###user user_table = table('user', column('Id', sa.VARCHAR(20)), column('create_at', sa.DATE), column('password', sa.VARCHAR(20)), column('authority', sa.Enum("Admin", "Developer", "Member", name = "authority")), column('name', sa.VARCHAR(30)), column('phone', sa.VARCHAR(20)), column('email', sa.VARCHAR(100)), column('member_balance', sa.Integer)

Nov 29, 2022
4.2 Expectation of the possible DB operations, frequencies and data volumes

Assume : User = 10000, Game = 800, Table 可能操作 預估使用頻率(per day) 表格資料量(tuples) 系統負擔(worst case) user user登入身分驗證

Nov 28, 2022
Read more from 資料庫系統
Published on HackMD