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

        代寫ECS 116、代做SQL設(shè)計(jì)編程

        時(shí)間:2024-04-30  來(lái)源:合肥網(wǎng)hfw.cc  作者:hfw.cc 我要糾錯(cuò)



        ECS 116 Databases for Non-Majors / Data Management for Data Science
        Programming Assignment 1
        A. Prelude
        1. The assignment is of 25 points.
        2. Last date of submission is April 28, Sunday @ 11:59 pm.
        3. Late submissions will be graded according to the late policy. Specifically, 10% of grade is deducted if you are
        up to 24 hours late, 20% is deducted if you are 24 to 48 hours late, and no credit if turned in after 48 hours.
        4. This assignment will be solo.
        5. Create a new sql file for each step namely (Step 2, Step 3, Step 4) if you have to use sql commands through
        DBeaver.
        6. Your assignment will be graded based on correctness (passing all tests), ingenuity and originality.
        7. All the required files (csv) can be found under Files in Canvas.
        8. Plagiarism is strictly prohibited. You’re free to discuss high-level concepts amongst your peers. However,
        cheating will result in no points on the assignment and reporting to OSSJA.
        B. Step 1: Uploading africa fs after cleaning db.csv into PostgreSQL
        1. In DBeaver create a new database faostat. Set that as the default database
        2. Create a schema food sec (or “food sec v01”) in your database faostat. Set that as default schema.
        3. Do set search path to food sec;
        4. Load the file africa fs after cleaning db.csv into the schema food sec to make table africa fs ac.
        5. Modify the data types of some of the columns of africa fs ac as follows:
         area code m49: varchar(3)
         element code: varchar(4)
         year code: varchar(8)
         value: numeric
         After making these changes, click on “Save” at bottom of pane.
        6. Check whether the values for value column have been imported correctly.
         Do a selection query to get distinct values that are ≤ 2.
         Using Excel see what are the values ≤ 2.
         Do these match?
        7. Do an SQL query to DELETE all tuples from africa fs ac (it will ask you to confirm that you want to do this
        delete).
        8. Use DBeaver to import the file africa fs after cleaning db.csv (don’t use the SQL “COPY” command
        because it complains about a data type encoding issue).
         Do a sanity check that the number of tuples in your table is same as in csv file.
         Again check on the values in column value.
        1
        C. Step 2: Build Table gdp stunting overweight anemia
        1. Similar to the construction of gdp stunting overweight shown in the 2024-04-09 lecture and the SQL script
        faostat-part 02-transforming africa fs.sql, use DBeaver and SQL commands to build a table
        gdp stunting overweight anemia which has, for each country-year pair the following associated values for:
         GDP per capita Purchasing Power Parity (22013): use column name gdp p ppp.
         Percentage of children over 5 years of age who are stunted (21025): . childhood stunting
         Percentage of children over 5 years of age who are overweight (21043): childhood overweight.
         Prevalence of anemia among women of reproductive age: anemia
        2. Add this table into your schema food sec.
        Figure 1: Almost correct example of the table gdp stunting overweight anemia. Your table should have 3 characters
        for area code m49 column, and may have some decimal values for the last 4 columns.
        D. Step 3: Build table energy undernourished
        1. Note that many records in africa fs ac have year and year code values based on 3-year intervals rather than
        single years. We will use some of this data to gain more insight about countries. In particular, we will interpret
        a 3-year interval as applying to the year in the middle, e.g., we will interpret 2000-2002 as applying to the year
        2001.
        2. First, build a table energy undernourished which has, for each country-year code pair the associated values
        for:
         Average dietary energy supply adequacy (21010): use column name dietary energy.
         Prevalence of undernourishment (210041): use column name undernourished.
         Note: this table should have 1040 rows in it.
        3. Now add a column derived year to the table energy undernourished, where for each tuple, the derived year
        value is computed by using the year in the middle of the first and third years in the year code of the tuple.
        4. The column you added probably has data type integer. Convert this to varchar(4).
        2
        Figure 2: Almost correct example of the table energy undernourished. As with Figure 1, the area code m49 column
        should have 3 characters, and the values for last 3 columns may have decimal values.
        E. Step 4: Joining the gdp stunting overweight anemia and
        energy undernourished tables to create new
        table gdp energy with fs indicators
        1. Create a selection query that combines the table gdp stunting overweight anemia and energy undernourished
        to form a new table gdp energy with fs indicators
         The columns should include area code m49, area, year code, gdp pc ppp, dietary energy, childhood stunting,
        childhood overweight, anemia and undernourished.
         Tuples in this table should be formed by combining tuples from gdp stunting overweight anemia and
        energy undernourished where year code from the first table equals derived year of the second table.
         Note: your table should have 895 tuples in it.
        2. Export the table gdp energy with fs indicators as a csv file gdp energy with fs indicators.csv.
        3. Sort this csv file by area (country name) and then year code.
        4. CONGRATULATIONS: you have created a table that we can use later to determine whether there are sta?tistical correlations between gdp per capita and/or stunting, childhood overweight, anemia in women and/or
        undernourishment.
        Figure 3: Example of the table gdp energy with fs indicators
        5. Create a new table gdp energy fs aggs.
         Which has columns as:
        – area code m49
        – area
        – avg gdp pc ppp
        – avg dietary energy
        3
        – avg childhood stunting
        – avg childhood overweight
        – avg anemia
        – avg undernourished
         The “avg” columns should hold the averages of the corresponding items for each country, over all of the
        years of available data.
         Use the round operator on the “avg” value, so that they have type numeric and are rounded to 2 decimal
        points. Use the following kind of expression: round(< expression for average >::numeric, 2).
        6. Export the table gdp energy fs aggs as a csv file gdp energy fs aggs.csv.
        7. Sort the csv file by area (i.e., country name).
        Figure 4: Almost correct example of the table gdp energy fs aggs. You will obtain slightly different values. This
        table was computed with rounded values for various columns, rather than with values having decimals.
        F. Submission
        1. Please make a single zip file that includes
         gdp energy with fs indicators.csv
         gdp energy fs aggs.csv
         The DBeaver sql scripts that you used to create these 2 csv files, specifically, Step 2.sql, Step 3.sql,
        Step 4.sql).
         Name the zip file as FirstName LastName LastFourDigitsOfStudentID ECS116 A1.
        2. Upload it on Canvas for Assignment 1 (This is a solo assignment so don’t add your peers to your submission).

        請(qǐng)加QQ:99515681  郵箱:99515681@qq.com   WX:codinghelp














         

        掃一掃在手機(jī)打開當(dāng)前頁(yè)
      1. 上一篇:CS 6347代做、MATLAB程序設(shè)計(jì)代寫
      2. 下一篇:菲律賓達(dá)沃景點(diǎn)(達(dá)沃著名景點(diǎn)介紹)
      3. 無(wú)相關(guān)信息
        合肥生活資訊

        合肥圖文信息
        急尋熱仿真分析?代做熱仿真服務(wù)+熱設(shè)計(jì)優(yōu)化
        急尋熱仿真分析?代做熱仿真服務(wù)+熱設(shè)計(jì)優(yōu)化
        出評(píng) 開團(tuán)工具
        出評(píng) 開團(tuán)工具
        挖掘機(jī)濾芯提升發(fā)動(dòng)機(jī)性能
        挖掘機(jī)濾芯提升發(fā)動(dòng)機(jī)性能
        海信羅馬假日洗衣機(jī)亮相AWE  復(fù)古美學(xué)與現(xiàn)代科技完美結(jié)合
        海信羅馬假日洗衣機(jī)亮相AWE 復(fù)古美學(xué)與現(xiàn)代
        合肥機(jī)場(chǎng)巴士4號(hào)線
        合肥機(jī)場(chǎng)巴士4號(hào)線
        合肥機(jī)場(chǎng)巴士3號(hào)線
        合肥機(jī)場(chǎng)巴士3號(hào)線
        合肥機(jī)場(chǎng)巴士2號(hào)線
        合肥機(jī)場(chǎng)巴士2號(hào)線
        合肥機(jī)場(chǎng)巴士1號(hào)線
        合肥機(jī)場(chǎng)巴士1號(hào)線
      4. 短信驗(yàn)證碼 酒店vi設(shè)計(jì) NBA直播 幣安下載

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

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

        主站蜘蛛池模板: 日本一区二区三区在线视频| 亚洲欧美日韩一区二区三区| 日韩国产精品无码一区二区三区 | 麻豆一区二区三区精品视频| 91久久精品国产免费一区 | 日本一区免费电影| 亚洲成在人天堂一区二区| 爆乳熟妇一区二区三区| 国产精品美女一区二区三区| 无码人妻精品一区二区三区99仓本| 深田咏美AV一区二区三区| 久久精品国产亚洲一区二区三区| 日本精品一区二区久久久| 精品人妻AV一区二区三区| 亚洲国产精品一区二区第一页| 久久se精品一区二区国产| 色欲AV无码一区二区三区| 无码中文人妻在线一区| 精品深夜AV无码一区二区| 精品无码人妻一区二区三区 | 国产主播在线一区| 日韩av片无码一区二区三区不卡 | 99精品一区二区三区| 久久亚洲中文字幕精品一区| 高清在线一区二区| 人妻无码一区二区三区四区| 国产aⅴ精品一区二区三区久久 | 国产一国产一区秋霞在线观看| 亚洲日韩AV一区二区三区中文| 久久伊人精品一区二区三区| 亚洲熟妇av一区二区三区| 中文字幕国产一区| 日本不卡免费新一区二区三区| 精品人妻AV一区二区三区| 日产精品久久久一区二区| 亚洲国产老鸭窝一区二区三区| 亚洲中文字幕一区精品自拍| 国产精品一区视频| 国产福利无码一区在线| 一区二区日韩国产精品| 日韩精品一区二三区中文|