Can you please create an ER diagram model for the Open Kattis System website. For the ER diagram, you need to model the data that would be needed to recreate all of the web pages that are displayed to ordinary contest observers or participants on OpenKattis. You do not need to model any additional data that is revealed only when you set up a contest, or create a new problem. Also can you explain the solution, thanks!!

Can you please create an ER diagram model for the Open Kattis System website. For the ER diagram, you need to model the data that would be needed to recreate all of the web pages that are displayed to ordinary contest observers or participants on OpenKattis. You do not need to model any additional data that is revealed only when you set up a contest, or create a new problem. Also can you explain the solution, thanks!!

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

11th Edition

ISBN:9781305494602

Author:Scott Tilley, Harry J. Rosenblatt

Publisher:Scott Tilley, Harry J. Rosenblatt

Chapter2: Analyzing The Business Case

Section: Chapter Questions

Problem 10Q

See similar textbooks

Similar questions

Can you please create an ER diagram model for OPEN KATTIS WEBSITE WITH 7 ENTITIES. For the ER diagram, you need to model the data that would be needed to recreate all of the web pages that are displayed to ordinary contest observers or participants on OpenKattis. You do not need to model any additional data that is revealed only when you set up a contest, or create a new problem
Create a CRUD matrix to check the consistency between your domain model class diagram (create it) and your complete list of use cases (create and list them). Set this out in the form of a table with classes as the columns and use cases as the rows. Weddings, Parties, Everything is a rapidly-growing online business that links together customers who need a caterer for their event with businesses that provide catering. Customers input their location and requirements, and are presented with a shortlist of potential caterers who may be able to provide what they need.WPE has been partly manual for the first few months of their operation, but now needs new system to automate business of putting together the right customer with right caterer. intend to roll system out nationally, from original base in WA. Edison Guacamole, owner/manager of WPE, has contacted you for help.two sides to system are, caterers & customers.Caterers register on WPE system by providing business name, description,…
Draw an ER diagram for the following scenario- • An instructor has an ID, a name, and a phone number. An instructor teaches a course • A course has a code, course name, credits, and an instructor. Each course uses a textbook. • A textbook has ISBN, name, publisher, editor, and authors. Your ER diagram should have entities, attributes, composite attribute, multivalued attribute, key attributes, binary relationships, and a total participation. Explain your rationale behind each design choice. Please draw the ER diagram on paper showing all seperate parts for each instructor, course and textbook. Showing each connection seperately and explaining which connection is which
Develop a context diagram and level-0 diagram for the hospital pharmacy system described in the following narrative. If you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Supply these extra explanations along with the diagrams. The pharmacy at Mercy Hospital fills medical prescriptions for all hospital patients and distributes these medications to the nurse stations responsible for the patients’ care. Prescriptions are written by doctors and sent to the pharmacy. A pharmacy technician reviews each prescription and sends it to the appropriate pharmacy station. Prescriptions for drugs that must be formulated (made on-site) are sent to the lab station, prescriptions for off-the-shelf drugs are sent to the shelving station, and prescriptions for narcotics are sent to the secure station. At each station, a pharmacist reviews the order, checks the patient’s file to determine the appropriateness of the prescription, and fills the order if the…
create an Enhanced Entity-Relationship (EER) diagram based on the provided information. Based on the following description, try creating the diagram using a tool such as draw.io, Lucidchart, or any other ER diagram tool: Entities: Person: person_ID (PK), name, address, birth date, phone number Subtypes: Employee, Physician, Patient, Volunteer Visit: date (PK, partial identifier), comments Care Centre: care_centre_ID (PK), name, location Laboratory: lab_ID (PK), name, location Bed: bed_number (PK), room_number, care_centre_ID (FK) Item: item_number (PK), description, unit_cost Treatment: treatment_ID (PK), treatment_number, treatment_name, treatment_date, treatment_time, results Relationships: Works_In (Person - Care Centre): Person (1, M) ----< Works_In >---- (1, M) Care Centre Assigned_To (Employee - Care Centre): Employee (1, M) ----< Assigned_To >---- (1, M) Care Centre Assigned_To (Physician - Care Centre): Physician (1, M)…
Describe the potential issues as you construct the framework, then assess the challenges and bottlenecks that could appear when you implement the different solutions you have suggested. Either yes or no is the response to this query. Is this something you ought to pay attention to, or ought you to ignore?
Based on: Entity-Relationship Diagram with the following requirements: There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_Date There are Flubs (ie posts) with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor) There are Bounces (ie shares) where a Professor can share another Professor's Flub Add ID attributes as necessary Content of Flubs only needs to be a text of fixed length Professors can have/be Colleagues (ie friends/followers) A Flub can get Citations (ie likes) by other Professors Show the Relational Algebra AND Domain Relational Calculus formulas for each. Show a portfolio of the Flubs by a Professor Show a portfolio of all Flubs and Bounces (the Flubs bounced) by all of a Professor's Colleagues
Based on: Entity-Relationship Diagram with the following requirements: There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_Date There are Flubs (ie posts) with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor) There are Bounces (ie shares) where a Professor can share another Professor's Flub Add ID attributes as necessary Content of Flubs only needs to be a text of fixed length Professors can have/be Colleagues (ie friends/followers) A Flub can get Citations (ie likes) by other Professors Create the SQL for a single View called "Flubbergasting" of a Professor which includes all attributes from Entity-Relationship Diagram, as well as how many Flubs, the average number of Bounces the Flubs had, and total Citations across all Flubs by that professor.
Identify the Actors and the Use Cases from the customer requirements in Appendix-A . Briefly describe them and draw the use case diagram using an UML tool . Prepare Detailed Use Case Descriptions with UML Activity Diagrams for “Submit Homework” and one other Use Case you identify from Moodle (Student Information System) software that has actor of type “student”. For all diagramming use Gliffy (https://www.gliffy.com/) or another UML modeling tool you prefer. APPENDIX-A Online Hotel Reservation System RichOS hotels owner Mr. Tompkins wanted an online reservation system (HORSE) for his new hotel located in Antalya. The hotel has two types of rooms: regular and suit. In order to make a reservation or cancel any other, the clients (persons or travel agency) must logon the system. The clients should register to the system through their names, e-mail and telephone information. Clients will be able to query the availability of the rooms selecting a date interval and room type. The client will…
QUESTION 6 Design an ER diagram for the scenario below, showing all attributes, keys, cardinalities and participation constraints clearly. Note any unspecified requirements, and make appropriate assumptions to make the specification complete. Do not add any attributes of your own. Upload your ER model below, please note: Make sure that the image is clear.Accepted File formats are: JPEG, PNG, or PDF, Other formats are not accepted.Do not include links to external resources.Clearly write your name and ID on the ER image. Otherwise, it will not be accepted. Question: Consider the following requirements for a hospital database to store information about the hospital departments and employees. The hospital has several departments. Each department has a unique name, unique telephone number, and a specific employee managing the department. Each department is related to one or more divisions, and the division-no is unique within the department. Each division has a telephone-number and may…
Continuing with the Vince's Vinyl scenario from Hands-On Database, in an Excel spreadsheet, take a look at each of the forms and make a list of all the nouns. Set up some preliminary entities and identify some key fields.
Which one is the right answer? 1. Generating alternative initial designs would most likely be done during which phase?a. Design b. Intelligence c. Implementation d. Choice 2. The difference between front and back office systems is a. Front office systems are external systems, back office systems are internal b. Front office systems are web based, back office systems are built on database systems c. Front office systems process information at the beginning of a customer’s transaction, back office systems process information at the end of a customer’s d. Front office systems focus on getting the sales, back office systems focus on follow up