代做ITS62904 DATABASE SYSTEMS ASSESSMENT 3代写数据库编程

TAYLOR’S UWE DUAL AWARDS PROGRAMMES

SEPTEMBER 2024 SEMESTER

(ITS62904)

DATABASE SYSTEMS

ASSESSMENT 3 (GROUP ASSIGNMENT)

30%

DUE DATE: 9/12/2024, 8:00am

Learning Outcome Assessed:

Construct solutions, interact positively in a group of peers and foster stable and harmonious relationships in solving computational problems related to database modelling and SQL based reporting of a selected scenario.

TASK

NOTE: Before you begin modelling read the:

1. SRS

2. Read BPC version V1.1.1

3. SQL Report

As you many need to include additional attributes in some of the table to ensure you can generate the SQL reports accurately.

A. Database Design (20%)

1. Draw a complete Conceptual Enhanced Entity-Relationship Diagram (EERD)

a. List all attributes, ensure you identify the identifiers.

b. Map the entities with appropriate relationships.

2. Physical Model → Provide the necessary information for the Model (Relational Model - ensure data integrity).

a. Include explanation on Open suggestion or changes made to the model.

B. Deployment: create database, tables and populate the data (20%)

3. 20+ rows of valid records if it’s applicable). This may not be applicable for all table but ensure that the sample data reflects the client’s information and the types of memberships and the types of workshops or seminar they attend. Ensure data across tables is consistent and adheres to the defined rules. Clients and class tables should have at least 30 records.

C. SQL Report (20%)

4. List the workshop with the highest total revenue for Bella Italia Culinary Studio.

5. Get a list of clients who have registered for seminars, sort the report by client name and workshop date.

6. Produce a report of client information who have attended workshops or seminar for last 3 months (June, July & August 2024), you should include details like membership type, total loyalty points earned, and the total number of workshops or seminars attended.

7. Generate a report showing the total number of clients registered for each cooking workshop, categorized by the "Difficulty Level" and brand ("Gourmet Gurus," "Master Chef Club," or "All").

8. List all of chefs who have conducted workshops in the past year, along with their culinary specialties, number of workshops conducted, and total attendance at these workshops.

9. Create a comprehensive report detailing all client activities, including workshops attended, equipment rented, and points earned, segmented by membership type.

D. Analysing database structure and designing useful reports (20%)

10. Develop five (5) different types of reports using SQL queries to demonstrate the ability to analyse data stored across various tables. These reports should provide in-depth insights relevant to the culinary studio's operations. Marks for this section will be allocated based on the complexity of the queries and the students' ability to effectively analyse the recorded data.

Note: ensure to write out the purpose of each query.

E. Unforeseen challenges (Research) (20%)

11. Considering the unforeseen challenges posed by climate change, what significant changes should be made to the design and development of BICS database system? Discuss the specific features, such as transaction management and concurrency control, and the information needs required to effectively address the problems presented by climate change.

Marks Tabulation process:

Students need to be aware that database design outcome effects the development process of the database (SQL outcome). If the design is not being properly considered, then the implementation and roll-out carriers the effect of the database design.

In the case of poor database design, a simple reduction of marks with design, will be carried to development as well. Incorrect and inaccurate design leads to incorrect and inaccurate development as well, even though the implementation is completed.




热门主题

课程名

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
站长地图