代做COMP508 DATABASE SYSTEM DESIGN SEMESTER 1, 2025代做SQL语言

COMP508 DATABASE SYSTEM DESIGN

SEMESTER 1, 2025

Paired Assignment

Database Project                                                                                               50% of the final grade

Due: 5:00 pm, 13th June 2025

Part

Tasks

Marks

Part A

Entity Relationship Modelling and Logical Database Design

Tasks 1 and 2

35

Part B

Database Implementation

Tasks 3 and 4

35

Part C

Construct SQL Queries

Task 5

30

1. Introduction to Assignment Requirements

This assignment is designed to  provide students with practical exposure to the stages involved in database development, including the development of entity relationship modelling, database design and  implementation.  It  provides  an  opportunity  for  students  to  apply to  a  larger  case  study the database concepts discussed in class and practised in exercises.

A separate document on Canvas: Assignments – ‘Case Study for Database Project’, describes the case study in detail. Please read the case study carefully. Students may ask for additional clarification of the case study on the discussion board on Canvas.

This  is a  paired assignment.  Pairs  of students within the same  lab stream  should complete tasks together.  However, you  have the  option to work  independently with the approval of the Course leader.

The details of the three parts of the assignment and the tasks are specified in Section 2. Section 3 describes the submission details and dates. The marking scheme is in Section 4.

Expectations

The assignment includes 3 parts. Part A consists of Tasks 1 and 2. Part B is comprised of Tasks 3 and 4. Part C has task 5. Students are required to attempt all the tasks.

Tools & Templates

You must use Oracle SQL Developer and the specified CASE tool, Visual Paradigm CE version for this assignment.

Plagiarism

Plagiarism means borrowing from the work of another without indicating by referencing that the ideas expressed are not one’s own.

Unauthorised Collaboration

Unauthorised collaboration means joint effort between students or students and others in preparing material  submitted  for  assessment,  except  where  this   has   been   pre-approved  by  the  paper programme. Students are encouraged to discuss matters covered in classes, but the expression of ideas and arguments must be the student’s work.

ACADEMIC INTEGRITY GUIDELINES

AUT takes Academic Integrity very seriously and you are reminded that the following actions may be deemed to constitute a breach of the General Academic Regulations Part 7: Academic Discipline, Section 2 Dishonesty During Assessment or Course of Study

.    2.1.1 copies from, or inappropriately communicates with another person

.    2.1.3 plagiarises the work of another person without indicating that the work

is not the student’s own – using the full work or partial work of another person without giving due credit to the original creator of that work

.    2.1.4 collaborates with others in the preparation of material, except where this has been approved as an assessment requirement.

.    2.1.5 resubmits previously submitted work without prior approval of the assessment board

.    2.1.6 using any other unfair means.

ADDITIONAL INFORMATION

.    Your assessment  responses must be your own work. You may be required to orally defend your responses to assessment questions.

2. Assignment Parts and Tasks

Part A Entity Relationship Modelling and Logical Database Design (35 marks)

Task 1  Identify Entities & Develop Business Rules                                                         [10 marks]

Identify all entities and relationships in the case study and develop a set of business rules. You should follow the syntax given below. Two rules must describe each relationship, one in each direction.

Each ENTITY_ 1 May/Must Relationship_Verb_Phrase number ENTITY_2

Task 2  Construct a logical Entity Relationship Diagram (ERD)                                     [25 marks]

Based on the business rules developed in Task 1, construct a logical ERD for the case study using the Visual Paradigm tool.

.    Identify all attributes in each entity, including all primary and foreign keys (transform any composite and multivalued attributes according to the rules of the relational model).

.    Name all relationships (i.e. you must use verb phrases on both sides of each relationship)

.    Identify the Cardinality and Participation for each relationship.

.    Resolve all many-to-many (M:N) relationships.

.    Describe any assumptions you have made in a text note on the diagram.

Please note: You don’t need to identify data types in your ERD.

Part B Database Implementation (35 marks)

In this part, you should develop a database based on your logical ERD developed in Part A. You must populate the tables with realistic sample data.

Task 3  Create tables [25 marks]

Create the tables in Oracle. Write SQL scripts defining each table. The table definitions should include

.          All attributes with appropriate data types

.          All appropriate constraints, such as primary key, foreign keys, and check statements (CHECK constraints).

.          All constraints must be given names. Naming standards must be used.

Task 4  Populate data                                                                                                             [10 marks]

Insert a small sample of realistic test data (5 –10 rows minimum) into each table. All test data must be meaningful to demonstrate your understanding of the data.

After creating all your tables (Task 3) and inserting data (Task 4), run the SQL SELECT statement below:

SELECT table_name FROM user_tables;

The statement will retrieve a list of all tables in your Oracle account (i.e., all tables you created this semester). Include the results of the SELECT statement in your assignment.

You must also include the following for each table in your database:

.    SQL table creation script.

.    SQL insert script (used for inserting sample data)

.    Evidence of Sample data - you must run SELECT * FROM table_name(where table_name is the table's name) for each table in Task 3 and include results of SELECT statements for each table.

Part C Construct SQL Queries (30 marks)

Task 5  Construct SQL Queries [30 marks]

Identify five data retrieval requirements that would be used by the business described in the case study. Construct a SQL query to display the data for each requirement you have identified. So, you must construct five SQL queries in total. The queries must include a combination of the following SQL features:

.    Use of restriction (WHERE clause), Arithmetic expressions, Concatenation of columns

.    Use of comparison and logical operators

.    Multiple tables join (e.g., Equijoin, Outer Join, and Self-join)

.    Group functions (e.g., COUNT, SUM, AVG,  MAX,  MIN) and clauses (e.g., ORDER BY, GROUP BY, HAVING)

Note:

1. Your queries can combine the above features, which can be spread across the five queries, i.e., not all features need to be present in a single query. The design of each query should demonstrate your knowledge and application of SQL content covered in the course and your understanding of the correct usage of the various features and clauses of SQL. A simple select

* from table_name will fetch you a mark of zero in this task.

2. There should be no more than one query that involves a single table.

3. An example of a query is given on the next page.




热门主题

课程名

mktg2509 csci 2600 38170 lng302 csse3010 phas3226 77938 arch1162 engn4536/engn6536 acx5903 comp151101 phl245 cse12 comp9312 stat3016/6016 phas0038 comp2140 6qqmb312 xjco3011 rest0005 ematm0051 5qqmn219 lubs5062m eee8155 cege0100 eap033 artd1109 mat246 etc3430 ecmm462 mis102 inft6800 ddes9903 comp6521 comp9517 comp3331/9331 comp4337 comp6008 comp9414 bu.231.790.81 man00150m csb352h math1041 eengm4100 isys1002 08 6057cem mktg3504 mthm036 mtrx1701 mth3241 eeee3086 cmp-7038b cmp-7000a ints4010 econ2151 infs5710 fins5516 fin3309 fins5510 gsoe9340 math2007 math2036 soee5010 mark3088 infs3605 elec9714 comp2271 ma214 comp2211 infs3604 600426 sit254 acct3091 bbt405 msin0116 com107/com113 mark5826 sit120 comp9021 eco2101 eeen40700 cs253 ece3114 ecmm447 chns3000 math377 itd102 comp9444 comp(2041|9044) econ0060 econ7230 mgt001371 ecs-323 cs6250 mgdi60012 mdia2012 comm221001 comm5000 ma1008 engl642 econ241 com333 math367 mis201 nbs-7041x meek16104 econ2003 comm1190 mbas902 comp-1027 dpst1091 comp7315 eppd1033 m06 ee3025 msci231 bb113/bbs1063 fc709 comp3425 comp9417 econ42915 cb9101 math1102e chme0017 fc307 mkt60104 5522usst litr1-uc6201.200 ee1102 cosc2803 math39512 omp9727 int2067/int5051 bsb151 mgt253 fc021 babs2202 mis2002s phya21 18-213 cege0012 mdia1002 math38032 mech5125 07 cisc102 mgx3110 cs240 11175 fin3020s eco3420 ictten622 comp9727 cpt111 de114102d mgm320h5s bafi1019 math21112 efim20036 mn-3503 fins5568 110.807 bcpm000028 info6030 bma0092 bcpm0054 math20212 ce335 cs365 cenv6141 ftec5580 math2010 ec3450 comm1170 ecmt1010 csci-ua.0480-003 econ12-200 ib3960 ectb60h3f cs247—assignment tk3163 ics3u ib3j80 comp20008 comp9334 eppd1063 acct2343 cct109 isys1055/3412 math350-real math2014 eec180 stat141b econ2101 msinm014/msing014/msing014b fit2004 comp643 bu1002 cm2030
联系我们
EMail: 99515681@qq.com
QQ: 99515681
留学生作业帮-留学生的知心伴侣!
工作时间:08:00-21:00
python代写
微信客服:codinghelp
站长地图