INFO20003 Database Systems
Dr -Gajic Dr
INFO20003 Database Systems 1
Copyright By PowCoder代写 加微信 powcoder
Let’s get to know you first
•Please go to: PollEv.com/rbor
INFO20003 Database Systems 2
What this subject is all about
Organisational Description
and Problem Area
• An investment bank wants to have a database to provide it with the ability to store information about its trading operations. The bank essentially works with customers by providing the capability for trading stocks, shares and other commodities. The bank has three branches in which exist a number of departments. Departments have a department manager who supervises a number of staff within the department. A set of accounts are used to store information about the currency of the organisations operations. Accounts can be customer accounts or internal “house” accounts, each of which allow trades to be made upon them. There are a number of account types. There are many customers and customers may have one or more contacts. Customers have a facility for lending money to pay for their purchases of stocks and commodities. Staff make deals on the behalf of their customers using a funding source and keeping track of settlements on the deals being made. There are many types of deal to be made. Settlements are full or partial payments of the deals and are recorded whenever a payment is made.
• Please note that this section is purely made up and by all means is a very short description of a real investment bank (although many details have been left out and wide ranging assumptions have been made.
MODELLING SQL ARCHITECTURE / INTERNAL WORKINGS
SQL Queries
select val from sales where id = max;
Process Access Store
Database System
INFO20003 Database Systems
© University of Melbourne 3
• LMS (up to date) allow minor changes here
W01 28-Feb
W02 07-Mar
W03 14-Mar
W06 04-Apr
W07 11-Apr
W10 09- 11 16- 12 23- 1
1. Introduction to the Subject and Database Systems
3. Introduction to ER Modelling
5. ER Example with MySQL Workbench
11. Query Processing-Part 1 (Selection & Projection)
Week by week schedule
2. The Database Development Process
4. Relational Model
6. Hands-on Modelling
MySQL Overview/Installation
Tutorial: Introduction to Database Development
Tutorial: Conceptual and Logical Modelling (ER)
Lab: ER modelling with MySQL Workbench
Lab: ER modelling with MySQL Workbench continued
Assessments
A01 ER post
W04 21-Mar
W05 28-Mar
7. Relational Algebra
9. SQL Summary
10. Storage and Indexing
12. Query Processing-Part 2 (Joins)
Tutorial: ER modelling case study
Tutorial: Relational Algebra and translation to SQL
Lab: ER modelling case study
Lab: SQL Skills
A01 ER DUE Friday
13. Query Optimization-Part 1
17. Database Administration
19. Data Warehousing
23. Review 1
14. Query Optimization-Part 2
18. Transactions
20. Distributed Databases
22. Adaptive databases for the future (nonexaminable: introducing database research avenues)
24. Wrap up and Review 2
Tutorial: Indexing and Storage
Tutorial: Query Processing
Tutorial: Database Administration and Transactions
Tutorial: Data Warehousing
Tutorial: NoSQL
Lab: More SQL Skills
Lab: Even More SQL Skills
Lab: Database Admin: Backup and Recovery
A02 SQL post
W08 25-Apr
W09 02-May
15. Normalization
16. Normalization (hands-on)
Mid-semester break (18-Apr)
Tutorial: Query Optimization
Tutorial: Normalization
Lab: Query Optimization using Execution Plan
Tutorial: Normalization
A02 SQL DUE Friday
21. Introduction to NoSQL
Lab: Transaction exercise using MySQL Workbench
Tutorial: Exam FAQs
A03 QP/QO Quiz
INFO20003 Database Systems © University of Melbourne 4
Organization
1. LECTURES 2. TUTORIALS
Teach concepts Apply
COMPLEMENTARY
Assessments:
1. Assignment 1: 10% (ER modelling)
2. Assignment 2: 10% (RA & SQL)
3. Assignment 3 (Quiz): 10% (Query Processing/ Optimisation)
4. Weekly quizzes: 10% (1% per week)
5. Final Exam: 60%
Practice at home
Hurdle 1 (15%)
BOTH REQUIRED
Hurdle 2 (35%)
INFO20003 Database Systems © University of Melbourne 5
A note on weekly quizzes
• 10 weekly quizzes, 1 mark worth each (low stakes)
• Short multi-choice questions, 5 questions, 20 mins
• Published on Fridays 6pm, due Monday 10am 9 days after
• You can attempt the quiz whenever you are ready BUT –It has to be during this timeframe
–You have 10min to complete once started (no pause/stop)
• Purpose is to practice and emphasize important things –Don’t worry if you don’t get things right (learning experience)
INFO20003 Database Systems 6
INFO20003 Staff
Lecturer: -Gajic
Head Tutor:
Tutors: Firman, Jian, Kyla, Kartika, Ohan, Prashansa, Tim, Kuoyuan,
INFO20003 Database Systems © University of Melbourne 7
Weekly engagement
• Watch pre-recorded videos (in Modules)
• Attempt weekly quizzes (graded 1 mark each, 20 min long)
• Attempt individual assignments (A1 and A2 assignments, A3 quiz)
Live (on Zoom or PAR- (MSD)-B117 – vote to be decided)
• One live lecture Q&A on Tuesdays 12pm (now)
• One tutorial per week (need to enrol)
• Three tutorial/lab consultations (Mon 1:15pm, Wed 12pm, Fri 5:30pm)
• Use ED discussion board for questions
INFO20003 Database Systems 8
Now your turn…
Are you interested in becoming a student representative?
(send me an email if yes)
INFO20003 Database Systems © University of Melbourne 9
Let’s now practice
Database development lifecycle
Role play (breakout groups)
• Lending books from a library
• Issuing fines by police for COVID ban violators
• Booking check ups with doctors
Split in two teams (customers and database designers)
Customers:
• Drive the conversation about requirements
Database designers:
• Clarify requirements, identify objects (entities)/connections
At this stage, this is still hard – but we will continue next week
INFO20003 Database Systems 10
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com