” INFO20003程序 写作、 辅导Python语言程序、Python程序INFO20003 S2 2020 Assignment 1INFO20003 Semester 2, 2020Assignment 1: ER ModellingDue: 6:00pm 4th September 2020The Royal SocietyThe Royal Society was founded in 1660 and is the oldest continuous scientific organisation inthe world. At any time, there are only 2000 members who have all achieved some scientificachievement such as a Nobel prize, Fields medal (mathematics) or Turing award (computerscience). You are requested to design a database to be used by The Royal Society.MembershipThe Royal Society has two categories of membership: fellowship and honoured fellowship.Within each category of membership there are several types of members. For example, in thefellowship there are: Provisional, Restricted and Full Membership. In the honouredfellowship category, there are Esteemed Royal fellow, Overseas fellow, 50 Year fellow, andLife fellow. You must first attain full membership as fellow of the Royal Society to beconsidered for an honoured fellowship category. We need to store the membership typehistory for all members tracking how they progressed through various memberships. Forexample, the dates they were a provisional member, then a restricted member and finally afull member of the Royal Society need to be captured.About each member of the Royal Society we store their title e.g. (Sir, Lord, Duchess,Earl, Barron, Professor, Dr, Mr and many more), their first name, middle names (ifany), last name, current residential address, email and phone number(s). One of the mostimportant details is the date they signed the Charter book which signifies the date theyformerly joined the Royal Society. The number in the charter book is their Royal Societymembership number. Royal Society also stores the date of death for deceased members.ApplicationINFO20003作业 写作、 辅导Python语言作业、Python程序To become a member of The Royal Society, an application is necessary. The application musthave the support of two Royal Society members who hold full membership or honoured fellowcategory status. Applicants must provide their first, middle names, last name, date of birth,home address, marital status, and the application must have two written references providedINFO20003 S2 2020 Assignment 1by the nominating members. The written references are stored in the database and must beno longer than 2,500 words. The member who nominates an applicant first serves as hisprimary referee and must provide a statement of achievement of no more than 300 words insupport of the application for membership. This statement is also stored with the application.The membership committee of the Royal Society approves or rejects applications. Thedatabase needs to store the date the applicant applied and the date and time the applicantwas approved. If a membership application is rejected, the database must record the date ofthe rejection and the reason for the rejection. There are currently 173 rejection categories andthe rejection types are frequently updated, but never deleted. For example, no member hasbeen rejected for a pistol dual since 3-August-1773. Once rejected, an applicant can reapplyfor membership after five years have elapsed. Subsequent re-applications are treated as newapplications but must be linked to the original application.EventMembers of the Royal society may organise different events. Events can be conducted in oneof the 12 rooms in the central London office of the Royal Society. In that case, members needto book a venue for their event as detailed below. Nowadays given the Coronavirus (COVID-19) pandemic situation, events such as summer science school are happening virtually. Forvirtual (online) events, there is no need of venue booking. Details about events such as eventtype, date, venue (if applicable), capacity limit, status (pending approval, upcoming,happening now, postponed, cancelled), online webinar link (if applicable) and registrationlink should be recorded. The Royal Society database stores only the registration link withoutany further details of the registration process.In case of cancelled events, the database updates the status of the event as cancelled butstill keeps the event in the database. Events can be public (such as conferences, lectures,workshops, training sessions and seminars), or private (such as scientific meetings anddinners). One or more members can be involved in organising a given event and beresponsible in different roles such as president, keynote speaker, chair, coordinator etc. Forpast public events such as lectures and trainings, one or more video or audio recordings canbe recorded and stored in the database to be made available to public.Venue BookingWith 12 rooms available for venue hire, the central London location of the Royal Society isideal for hosting events. Each room has different capacity depending on the roomorganisation/layout. For example, a conference room in theatre seating layout can host 60people but in boardroom layout the same room can host only 24 people. It is therefore crucialto record these details so organisers can make the right choice depending on the nature ofINFO20003 S2 2020 Assignment 1the event they are booking the venue for. Different layout settings include but are not limitedto theatre, board room, hollow square, U shaped, Round tables/dinners, cabaret style andreception. For each room we need to capture its dimensions (width and length) and the roomfloor.Any booking request can either be approved or rejected depending on the availability of venue.Also, each booking has a booking rate that depends on the capacity of the room (basic fee)and the event type. For example, education-related sessions have 50% discount over thebasic fee, while all private events are double the basic room fee.Business RequirementsYour database design needs to be able to meet the business need to answer questionssuch as: How long was Stephen Hawking a member of The Royal Society? How many members joined more than 50 years before they passed away? How many rejected applicants had Sir Isaac Newton as the Primary referee? Who applied the maximum number of times to be accepted by The Royal Society? What was the most common rejection reason for members rejected in the years 1700-1800? Which member has been involved in the most Gala events as keynote speaker? How many events received 50% discount in 2019? How many onsite public events have recorded videos of the event? Which room has the largest difference between its maximum and minimum capacitiesfor different configurations? How many scientific meetings are hosted in The Royal room using U shaped layout? What is the rate of conference room used for a python training workshop organised forcollege students?INFO20003 S2 2020 Assignment 1Instructions:Assignment 1 is worth 10% of your final mark. The assignment will be graded out of 100 marksas described in the table below:ER Physical Model with assumptions 80%Conceptual Model in Chens Notation 20%.mwb Physical Model File submitted Assignment Hurdle You are to analyse this Business Case and design a Conceptual ER Model in Chensnotation (can be hand drawn) as taught in class and a Physical ER Model for aMySQL Relational Database in Crows foot notation (modelled with MySQLWorkbench). You may list any assumptions you have made about the model on a separate page.There is a 400-word limit for assumptions. Assumptions must not be used to simplifythe assignment, but only to justify your decision about any ambiguity in the study. As part of your submission you must submit your final MySQL Workbench .mwb file ofyour Physical ER Model.NOTE: Items 1 (Conceptual Model Physical ER model) and 2 (Assumptions) must besubmitted as a single PDF. The title of the PDF document must be your student id (e.g.987654.pdf). Similarly, the title of your .mwb file should be your studentid.mwb (e.g.987654.mwb).Assignment Submission:You are to submit the assignment under the Assignments tab on Canvas LMS. Assignment 1has two submission links for the following files:1. ONE PDF document named as your student id (e.g. 987654.pdf) containing a legible (handdrawn) picture of conceptual model in Chens notation, a legible picture of your PhysicalER Model and your assumptions (if you stated any). Submit this single PDF documentunder the Assignment 1 PDF file link.NOTE: If you fail to submit legible models you will be penalised 10% of the mark for thisassignment.2. Your final .mwb MySQL Workbench file of the Physical ER model. Submit your .mwb fileunder the Assignment 1 mwb file link.INFO20003 S2 2020 Assignment 1Requesting a Submission Deadline ExtensionIf you need an extension due to a valid (medical) reason, you will need to provide evidence tosupport your request by 5pm, 3rd of September. Medical certificates need to be at least twodays in length.To request an extension: Email Farah Zaib Khan (farah.khan@unimelb.edu.au) from your university emailaddress, supplying your student ID, the extension request and supporting evidence. If your submission deadline extension is granted you will receive an email replygranting the new submission date. Do not lose this email!Reminder: INFO20003 Hurdle RequirementsTo pass INFO20003, you must pass two hurdles: Hurdle 1: Obtain at least 50% (15/30) or higher for the three assignments (each worth10%) Hurdle 2: Obtain at least 50% (35/70) or higher for the combination of quizzes and end ofsemester examTherefore, it is our recommendation to students that you attempt every assignment and everyquestion in the exam.GOOD LUCK!如有需要，请加QQ：99515681 或邮箱：99515681@qq.com
“
添加老师微信回复‘’官网 辅导‘’获取专业老师帮助，或点击联系老师1对1在线指导。
