亚洲天堂免费在线,丰满人妻在公车被猛烈进入电影,国产又黄又潮娇喘视频在线观看 ,久久黄色大片,国产女人伦码一区二区三区不卡,校花娇荡吟喘上课,亚洲区中文字幕在线不卡电影,亚洲黄色网页

合肥生活安徽新聞合肥交通合肥房產(chǎn)生活服務(wù)合肥教育合肥招聘合肥旅游文化藝術(shù)合肥美食合肥地圖合肥社保合肥醫(yī)院企業(yè)服務(wù)合肥法律

CHC5049 代做、代寫 SQL 編程設(shè)計
CHC5049 代做、代寫 SQL 編程設(shè)計

時間:2024-12-22  來源:合肥網(wǎng)hfw.cc  作者:hfw.cc 我要糾錯



CHC5049 Databases Coursework 2 Semester: 1, 2024-2025
CHC5049 Database Coursework 2.
Learning Outcomes
The two courseworks of this module address the following learning outcomes:
- Use SQL and XML to define data applications appropriate to a specified problem.
- Use a conceptual modeling language to specify and analyze data requirements
and apply database design principles to map system requirements to an efficient
(e.g., normalized) database.
- Explain and design transaction-based processing in database systems.
- Exploit techniques for storing and querying XML data.
OBJECTIVES
The objectives of this assignment are:
- To develop skills in the design of data-driven applications.
- To develop skills in applying SQL to implement the relational design.
- To develop skills in using SQL to define data applications.
- To present an opportunity to practice problem-solving and communication skills.
IMPORTANT INFORMATION
- Due date: December 23, 2024 (11:59 AM).
- Submit a PDF file via the online portal with all necessary screenshots, figures,
schemes, code, and test runs. State any assumptions made.
- The file must be named 'coursework2_StudentID.pdf'.
- This coursework is to be carried out individually.
- You have been given three CSV files (transactions, products, and customers)
along with a file description.
TASKS [30 marks total]
For the coursework submission, you should perform the following:
1) Examine the files and determine an appropriate relationship model between them. Create and document a physical data model detailing the field types and relationships. [5 marks]

CHC5049 Databases Coursework 2 Semester: 1, 2024-2025
2) Load all three tables into a new database schema. [3 marks]
3) Recommend and design one additional table that would be appropriate for more
efficient reporting of relevant data. [2 marks]
The three tables show data redundancies. The reporting system needs to accommodate at least ten years of data. It is unlikely that the current data model will support performance with the anticipated volume.
4) Redesign the data model to become more efficient for querying by detailing a logical data model showing elements of first and second normal forms where appropriate. [3 marks]
5) Create and document a new physical data model detailing the new structure, and create that structure within your database schema. [3 marks]
6) Ensure that the data is clean, and describe the steps taken. If you need to remove some of it, explain why that is the case. [2 marks]
7) Identify appropriate columns and create necessary indexes to optimize query performance. [2 marks]
8) Answer the following questions using database queries. Include your SQL statements and a screenshot of the output. [10 marks]
1. How many different products does the company sell?
2. How many products did the company sell in October?
3. How many customers have bought products from the company in October?
4. Which customer spent the most money with the company in October?
5. How many countries did the company ship products to in October?
6. Which state in America has the highest number of registered customers?
7. On which day were the most products sold?
8. Which development group had the most sales in October?
9. Which industry vertical had the lowest number of sales in October?
10. Which solution area has the lowest sales in the retail industry vertical?

請加QQ:99515681  郵箱:99515681@qq.com   WX:codinghelp





 

掃一掃在手機(jī)打開當(dāng)前頁
  • 上一篇:代寫 GR5280、代做 Java/Python 編程設(shè)計
  • 下一篇:COMP1038 代寫、C++編程設(shè)計代做
  • 無相關(guān)信息
    合肥生活資訊

    合肥圖文信息
    仿真分析咨詢外包服務(wù)-結(jié)構(gòu) / 熱 / CFD流體 / 電磁 / 光學(xué)CAE代做
    仿真分析咨詢外包服務(wù)-結(jié)構(gòu) / 熱 / CFD流體
    流體仿真外包多少錢_專業(yè)CFD分析代做_友商科技CAE仿真
    流體仿真外包多少錢_專業(yè)CFD分析代做_友商科
    CAE仿真分析代做公司 CFD流體仿真服務(wù) 管路流場仿真外包
    CAE仿真分析代做公司 CFD流體仿真服務(wù) 管路
    流體CFD仿真分析_代做咨詢服務(wù)_Fluent 仿真技術(shù)服務(wù)
    流體CFD仿真分析_代做咨詢服務(wù)_Fluent 仿真
    結(jié)構(gòu)仿真分析服務(wù)_CAE代做咨詢外包_剛強(qiáng)度疲勞振動
    結(jié)構(gòu)仿真分析服務(wù)_CAE代做咨詢外包_剛強(qiáng)度疲
    流體cfd仿真分析服務(wù) 7類仿真分析代做服務(wù)40個行業(yè)
    流體cfd仿真分析服務(wù) 7類仿真分析代做服務(wù)4
    超全面的拼多多電商運營技巧,多多開團(tuán)助手,多多出評軟件徽y1698861
    超全面的拼多多電商運營技巧,多多開團(tuán)助手
    CAE有限元仿真分析團(tuán)隊,2026仿真代做咨詢服務(wù)平臺
    CAE有限元仿真分析團(tuán)隊,2026仿真代做咨詢服
  • 豆包網(wǎng)頁版入口 Trae 目錄網(wǎng) 排行網(wǎng)

    關(guān)于我們 | 打賞支持 | 廣告服務(wù) | 聯(lián)系我們 | 網(wǎng)站地圖 | 免責(zé)聲明 | 幫助中心 | 友情鏈接 |

    Copyright © 2025 hfw.cc Inc. All Rights Reserved. 合肥網(wǎng) 版權(quán)所有
    ICP備06013414號-3 公安備 42010502001045