代做32606 Database代做数据库编程

32606 Database

Subject description

This subject introduces basic concepts of database design and its implementation, including relational design through entity-relationship diagrams and their interpretation. You'll learn to use SQL for data retrieval from databases and gain skills into the coding required for database implementation.

Subject learning outcomes (SLOs)

1. Design an Entity-Relationship (E-R) model from specifications and transform. a conceptual model into corresponding logical data structures. (C.1)

2. Construct Structured Query Language (SQL) statements and maintain a simple database. (D.1)

3. Critically evaluate database designs and the role databases play in effective software applications. (C.1)

4. Effectively communicate database design. (E.1)

Teaching and learning strategies

There will be a two-hour lecture and one hour of tutorial. The two-hour lecture slot will not be used entirely for content delivery, it will be used as a question-answer session as well. The one-hour lab will be used for gaining practical knowledge of SQL and designing ERD. However, during the lab time, there will be two assessments conducted which are SQL test1 and SQL test2. The lectures and labs will be conducted via Zoom interactive sessions.

Students collaborate by engaging in consultation with their peers and instructor to interpret design requirement and create entity relationship diagrams.

Assessments are designed in such a way that the students receive almost immediate feedback for every assessment item except for the final assessment.

Assessments 3 and 4, students will do a class tests, these assessments will test students’ ability to draw an E-R diagram from a given scenario and answer questions relating to database integrity.

For the final assessment the database project, students will create a database of their own choosing, their choice based on a database that is currently being used in the real world.

Please note that students are expected to put in additional study and practice time of your own in order to develop the practical skills necessary to fulfill the subject learning objectives.

Students are expected to use Canvas as part of their learning experience for this subject. Software tools to be used is PostgreSQL, which is a database management system, and other web-based applications that offer students the opportunity to develop their SQL skills.

Content (topics)

1. Introduction to Database Systems

2. Relational Data Model

3. Introduction to SQL: simple queries

4. SQL: aggregate functions, simple joins

5. SQL: complex joins, simple subqueries

6. SQL: data modification statements, set operators, views

7. Conceptual database design using E-R modelling

8. Normalisation

9. Logical design: E-R transformations

10. Transactions Management

Assessment task 1: SQL Lab Test 1

Description

Demonstrate basic SQL skills.

In this lab test, students will be required to successfully translate the given question statements in English into SQL queries that run on a computer. The queries are single table queries.

Each query will be marked as correct or incorrect.

The database to be used in this lab exam will be provided.

Learning Outcome

SLO2 Construct Structured Query Language (SQL) statements and maintain a simple database. (D.1)

SLO3 Critically evaluate database designs and the role databases play in effective software applications. (C.1)

Type Laboratory/practical

Groupwork Individual

Weight 20%

Length

Assessment feedback

The database info sheets will be provided in the test.

It is an open book test. Summative feedback will be provided during the class.

Assessment task 2: SQL Lab Test 2

Description

Test advanced SQL skills.

In this lab test, students will be required to successfully translate the given question statements in English into SQL queries that run on a computer. The queries are multi-table queries (i.e. these queries involve joining operation(s)).

Each query will be marked as correct or incorrect.

The database to be used in this lab exam will be provided.

Learning Outcome

SLO2 Construct Structured Query Language (SQL) statements and maintain a simple database. (D.1)

SLO3 Critically evaluate database designs and the role databases play in effective software applications. (C.1)

Type Laboratory/practical

Groupwork Individual

Weight 20%

Length

Assessment feedback

The database info sheets will be provided in the test.

It is an open book test. Summative feedback will be provided during the class.

Assessment task 3: Class test

Description

Test data integrity skills.

Two questions about Database Acid Properties & Data Integrity.

Learning Outcome

SLO3 Critically evaluate database designs and the role databases play in effective software applications. (C.1)

Type Examination

Groupwork Individual

Weight 20%

Length

Assessment feedback

It is an open book test. Summative feedback will be provided in class.

Assessment task 4: Class tests

Description

Test advanced entity relationship design skills.

Database ERD test.

Learning Outcome

SLO1 Design an Entity-Relationship (E-R) model from specifications and transform. a conceptual model into corresponding logical data structures. (C.1)

SLO3 Critically evaluate database designs and the role databases play in effective software applications. (C.1)

Type Design/drawing/plan/sketch

Groupwork Individual

Weight 20%

Length

Assessment feedback

It is a closed-book test.

Feedback: Summative feedback provided in class time.

Assessment task 5: MiniDatabaseProject

Description

Test all advanced database development skills.

Students will create a database of their own choosing, which should be a simplified version of a database used in a real-world software system, subject to minimum necessary conditions, such as minimum number of tables, and minimum number of relationship types, that will be specified in a separate document.

Learning Outcome

SLO1 Design an Entity-Relationship (E-R) model from specifications and transform. a conceptual model into corresponding logical data structures. (C.1)

SLO2 Construct Structured Query Language (SQL) statements and maintain a simple database. (D.1)

SLO3 Critically evaluate database designs and the role databases play in effective software applications. (C.1)

SLO4 Effectively communicate database design. (E.1)

Type Presentation

Groupwork Individual

Weight 20%

Length

Assessment feedback

Students who intend to do their database project assessment are advised to show their work to their subject coordinator/Lecturer before submitting. Usually it takes 2 meetings with the lecturer to finalise your assignment so that you can proceed with coding your database.