首页
网站开发
桌面应用
管理软件
微信开发
App开发
嵌入式软件
工具软件
数据采集与分析
其他
首页
>
> 详细
代写QHE5701、SQL编程语言代做
项目预算:
开发周期:
发布时间:
要求地区:
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
工作时间:8:00-23:00
微信:codinghelp
热点项目
更多
代写csc1001、代做python设计程...
2024-12-24
代写practice test preparatio...
2024-12-24
代写bre2031 – environmental...
2024-12-24
代写ece5550: applied kalman ...
2024-12-24
代做conmgnt 7049 – measurem...
2024-12-24
代写ece3700j introduction to...
2024-12-24
代做adad9311 designing the e...
2024-12-24
代做comp5618 - applied cyber...
2024-12-24
代做ece5550: applied kalman ...
2024-12-24
代做cp1402 assignment - netw...
2024-12-24
代写comm751/comm752 big data...
2024-12-24
代写business 114 accounting ...
2024-12-24
代做comp 273 project templat...
2024-12-24
热点标签
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
联系我们
- QQ: 9951568
© 2021
www.rj363.com
软件定制开发网!