INFO20003 Database Systems
Dr Renata Borovica-Gajic Dr
INFO20003 Database Systems
Copyright By PowCoder代写 加微信 powcoder
Administration
• Quiz 1 posted – due Monday 14/03/2022 10:00am (20 min duration) • We will talk about quizzes each week during Live Q&A (after due) Tutorials:
• Please attend your officially allocated tutorial as much as possible
• You are allowed to attend some other tutorial in addition to yours if you believe that would help with your learning, however please make sure not to disrupt students who are officially enrolled in that tutorial
What are workshop consultations?
• Consults covering tutorial and labs material
• Slots: Monday 1:15pm, Wednesday 12pm (non CS background),
Friday 5:30pm
• Slots are open for everyone – no need to register, simply pop in
• You can even attend them, sit quietly and attempt labs (help is there)
INFO20003 Database Systems 2
Student representatives
Your student representatives are:
• • JiWon Bae
INFO20003 Database Systems 3
Let’s test our understanding
•Please go to: PollEv.com/rbor
INFO20003 Database Systems 4
Let’s now practice
• This model has a number of mistakes. Identify the mistakes and redraw the model correctly.
name location
Department
manager ID ID
first name
desk phone
Phone number
suburb postcode
home phone
Post your answers here: https://padlet.com/renata_borovica/9p3tdve9s1vvfxem
INFO20003 Database Systems 5
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 entities/relationships
Then transform to logical design all together
INFO20003 Database Systems 6
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com