數據庫代寫 | LE/EECS 3421 – Introduction to Database Systems

專業CS代寫團隊5年代寫經驗,專注于CS作業代寫,Computer science代寫,Java代寫,Python代寫,C代寫,C++代寫,數據庫代寫,PHP代寫,算法作業代寫,CS homework代寫,R語言代寫, math代寫, 統計代寫, 金融代寫, business代寫, economic, accounting代寫等, 涉及英國CS代寫, 北美CS代寫, 加拿大CS代寫, 澳洲CS代寫, 新西蘭CS代寫, 香港CS代寫
Blog Details

數據庫代寫 | LE/EECS 3421 – Introduction to Database Systems

LE/EECS 3421 – Introduction to Database Systems
Winter 2021
英国作业代写,✔美国代考,【assignment代写】,business代写Programming Assignment 2

Question 1: Creating Schema [2+3+5 Marks]
Use the SQL script (a02script.sql) provided with the assignment to prepare the database schema. The ER
diagram from which this schema is adopted is provided in Appendix A (not precisely based on it). Before
you begin, you must make sure that you don’t have schema objects with the same names already in your
database. Furthermore, you have to make the following additions to the schema provided in this script:
? Create an additional summary table “CFPCount” which stores the count of CFPs of each type.
Also, write a suitable trigger to update this table “CFPCount” whenever a new CFP row/entry is
inserted or an existing is deleted. The details of this implementation are up to your imagination; as
long as it fulfills the purpose, your solution will be considered correct.
You are required to:
? Submit all the code for schema creation, after your additions, in a script file. Name this file as
yourID_q1.sql.txt.
? Run this script on your MySQL server and add the screenshots. Your screenshots must:
o Show the list of tables before the script is executed.
o Show the statement that executes the script and the success status of the script.
o Show the list of tables and other schema objects after the script is executed.
o The whole script must execute successfully.
Question 2: Scraping and Inserting Data [4+1 Marks]
Our next problem in this assignment is to extract the data from the CFP announcements and then insert it
into the Database using the suitable INSERT statements. Each student must process at least ONE CFP
announcement and create the INSERT statements for this CFPs. Select ONE (or more from the
additional file in case you are interested to insert more data) CFP announcement(s) from your designated
file (Appendix C), scrape the data from the CFP(s) (use the method described in Appendix B) and prepare
the INSERT statements accordingly. While scraping the data, you are not required to be precise;
make sure you process some meaningful information. You are required to:
? Submit all the code in a script file. Name this file as yourID_q2.sql.txt.
? Run this script on MySQL server and add the screenshots. Your screenshots must:
o Show the statement to execute script and the success status of script.
o The whole script must execute successfully.
Question 3: Inserting some more Data [5 Marks]
In order to make sure we have sufficient data to run queries, the students will share their scripts from
Question 2 with each other through the forum create on the eClass for this purpose. Every student will
take the script from at least 5 other students and merge into her/his own database. You are required to:
? Submit the code taken from other students in a script file. Name this file as yourID_q3.sql.txt.
? Mention the student names and IDs of the five students in your submission document.
? Run this script on MySQL server and add the screenshots. Your screenshots must:
o Show the statement to execute script and the success status of script.
o The whole script must execute successfully.
Question 4: Query the database [5+5 Marks]
Write the following two queries and execute them on the combined data of Question 2 and Question 3:
a) Display the count of each event type grouped based on the calendar months i.e., how many events
of each type happening in the months for which the data is present in the database. For
EventConference we will consider the EvDate field while for the other two event types it will be
the date of the earliest/lowest activity. You can show this query as three different queries for each
event type. Showing it as a single query will be considered for BONUS credit.
b) Display the one upcoming event for each event type i.e., the event with lowest date value for event
activity. For all event types it will be the date of the earliest/lowest activity. You can show this
query as three different queries for each event type. Showing it as a single query will be considered
for BONUS credit.

在線客服

售前咨詢
售后咨詢
微信號
Essay_Cheery
微信
北美 论文代写,金融代写,Assignment代写,英文论文润色-100%原创 作业代写,伦敦代写,澳洲代写assignment,,统计代写【包过】 代写被抓,英国代写,,CS作业代写,python代写,美国代写被抓怎么办? Essay代写,澳洲essay代写价格,网课代修,准时✔️高质数学代写 Essay代写,代写作业,网课代修代做-地表最专业的留学生代写机构 留学生代写,网课代修,代写英文-覆盖100+全学科report代写-Essayzhidao 英文论文代写,网课代修,英国、澳大利亚、北美等Essay代写推荐 网课代修,Assignment代写,美国英国留学生ESSAY论文作业代写最【靠谱】 加拿大澳洲英国代写,网课代上,网课代考,论文代写-assignment due® essay代写,留学生代写,英国硕士论文代,经济代写,数学,CS代写