程序代写案例-FIT2094

欢迎使用51辅导,51作业君孵化低价透明的学长辅导平台,服务保持优质,平均费用压低50%以上! 51fudao.top
27
FIT2094-FIT3171 Exam
31
Workshop Session 2 and 5 – Data Modelling
INCLUDING BUT NOT LIMITED TO THESE TOPICS...
▪Conceptual vs Logical Level
▪Entity
–Strong vs weak
–Associative entity
▪Types of attributes
▪Relationship
–Type : one-to-one, one-to-many, many-to-many
–Cardinality and Participation
–Identifying vs Non-identifying.
▪Mapping from Conceptual to Logical
–E.g. Mapping many-to-many
▪FIT3171 - UML
32
Workshop Session 3 – Relational Model
INCLUDING BUT NOT LIMITED TO THESE TOPICS...
▪Relational model properties.
▪Keys
–Superkey, Candidate Key, Primary Key
–Foreign Key
▪Data Integrity
–Entity integrity
–Referential Integrity
▪Relational Algebra
–Understanding of efficiency
33
Workshop Session 4 – Normalisation
INCLUDING BUT NOT LIMITED TO THESE TOPICS...
▪UNF to 3 NF
–Mapping form to UNF
–UNF to 1 NF – remove repeating group.
–1NF to 2 NF – remove partial dependency.
–2NF to 3NF – remove transitive dependency.
▪Dependency diagrams
–Use the general definition
–Partial in 1NF, Transitive in 2NF, Full in 3NF
•use this notation: cust_id → cust_name, cust_address
▪Be careful in choosing the PK!
▪Mapping a set of 3NF relations to a logical model
34
Workshop Sessions 6 and 8– DDL and DML
INCLUDING BUT NOT LIMITED TO THESE TOPICS...
▪DDL
–CREATE TABLE statements
•Primary key definition
•Foreign key definition
•Other Constraints
–ALTER
–DROP
▪DML
–INSERT
•Adherence to referential integrity constraints and the order of insertion
–Oracle Sequence
–UPDATE (DML)
–DELETE (DML)
–COMMIT
35
Workshop Session 7, 9 and 10 – SQL
INCLUDING BUT NOT LIMITED TO THESE TOPICS...
▪Single table retrieval with predicate
▪Join
–Natural join
–Outer join
▪Aggregate functions
▪Set Operators
▪Subquery
▪Oracle functions
TO_CHAR, TO_DATE, NVL, UPPER, LOWER, ROUND
36
Workshop Session 9 PLSQL and Workshop
Session 11 DB Connectivity, Web Technology
INCLUDING BUT NOT LIMITED TO THESE TOPICS...
▪Web database connectivity
–Understanding of the principles and ALL core concepts:
•Database middleware
•Web to database middleware
•Using PHP to communicate with databases
–must understand php code which relates to database
–Database design frameworks
•modern frameworks
•ORM
–Security → SQL Injection
▪FIT3171 - TRIGGER
37
Workshop Session 8 – Transaction Management
INCLUDING BUT NOT LIMITED TO THESE TOPICS...
▪Transaction.
▪ACID properties.
▪Transaction problems.
▪Transaction management with locks.
▪Wait For Graphs
▪Restart and Recovery using Transaction Log.

欢迎咨询51作业君
51作业君

Email:51zuoyejun

@gmail.com

添加客服微信: abby12468