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

合肥生活安徽新聞合肥交通合肥房產生活服務合肥教育合肥招聘合肥旅游文化藝術合肥美食合肥地圖合肥社保合肥醫院企業服務合肥法律

代寫QHE5701、SQL編程語言代做
代寫QHE5701、SQL編程語言代做

時間:2024-12-03  來源:合肥網hfw.cc  作者:hfw.cc 我要糾錯



QHE5701 – Database Systems 2024 
Lab – 5 1 
Lab 5: Designing Database and Generating sample data (using data generator tool) 
In this lab you’ll use MySQL to design and implement a database from user requirement. 
 
Database Specification Details: 
In a company that manages a big chain of doughnut-selling shops, there is a need to 
create a database for the data accumulated through the last years. Consider that the data 
you have available is: 
• List of menus which can be regular or seasonal (for example Christmas menu), 
they have a name and start and end date in case of a seasonal menu. Additionally, 
we also have a specific colour palette they must follow used by each menu. 
 
• List of products available for each menu we know names, prices, calories, sugar 
content, protein, and salt. 
 
• For the same sales, we know the buyer if they have scanned their loyalty app. A 
buyer has some data saved like first name, last name, gender, age and occupation. 
 
• Employees can have diTerent contracts (full-time, part-time) with additional total 
working hours (overtime). We also account for the years of experience of every one 
of them. 
 
• The branch is a location of our company that has an address and a size. Size is an 
index that describes how big is the branch. 
 
• List of ingredients used for every product (name, country of origin, units 
purchased, price, name of the supplier) 
 
• Each sale must be stored with the exact time and date of sale and price. 
 
NOTE: Assume that size is a parameter denoting roughly the cost of running that branch. 
 
Task: 
Design a database for this problem, which involves: 
i) Create an ER model for this problem 
ii) Perform the mapping to the logical model QHE5701 – Database Systems 2024 
Lab – 5 2 
iii) Produce the SQL code for the database 
iv) Create sample data for your database (to make it easier use a generator 
like: https://extendsclass.com/csv-generator.html ) 
 
Lab Submission Guidelines: 
Complete the task in Lab-5 as this will also be used in next lab. Details on Week-3 
submission will be provided with Lab-6 description. 

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




 

掃一掃在手機打開當前頁
  • 上一篇:PROG2004代做、代寫C/C++編程設計
  • 下一篇:代做ECE2810J、代寫C++語言程序
  • 無相關信息
    合肥生活資訊

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

    關于我們 | 打賞支持 | 廣告服務 | 聯系我們 | 網站地圖 | 免責聲明 | 幫助中心 | 友情鏈接 |

    Copyright © 2025 hfw.cc Inc. All Rights Reserved. 合肥網 版權所有
    ICP備06013414號-3 公安備 42010502001045