create ERD diagram $----$ Database: $`$ems$`----------------------------------------------------------------$ Table structure for table $`$absentees$`--$ CREATE TABLE $`$absentees$`(`$id$`$ int$(11)$ NOT NULL, $`$studentID$`$ int$(11)$ NOT NULL, $`$sectionID$`$ int$(11)$ NOT NULL, $`$date$`$ date NOT NULL, $`$courseName$`$ varchar$(255)$ NOT NULL, $`$studentName$`$ varchar$(255)$ NOT NULL $)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_$general$\_$ci; $----$ Dumping data for table $`$absentees$`--$ INSERT INTO $`$absentees$`(`$id$`,`$studentID$`,`$sectionID$`,`$date$`,`$courseName$`,`$studentName$`)$ VALUES $(9,3,2,\text{'}2024-12-22\text{'},$ 'Calculus I$\text{'},$ 'Salim'$),(10,4,2,\text{'}2024-12-22\text{'},$ 'Calculus I$\text{'},$ 'Rashid'$),(11,3,1,\text{'}2024-12-22\text{'},$ 'Data Structures', 'Salim'$),(12,4,1,\text{'}2024-12-22\text{'},$ 'Data Structures', 'Rashid'$)$; $--------------------------------------------------------------$ Table structure for table $`$change$\_$requests$`--$ CREATE TABLE $`$change$\_$requests$`(`$requestID$`$ int$(11)$ NOT NULL, $`$scheduleID$`$ int$(11)$ NOT NULL, $`$newDate$`$ date NOT NULL, $`$newTime$`$ time NOT NULL, $`$lecturerID$`$ int$(11)$ NOT NULL, $`$requestDate$`$ timestamp NOT NULL DEFAULT current$\_$timestamp$(),`$requestStatus$`$ varchar$(50)$ NOT NULL DEFAULT 'pending' $)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_$general$\_$ci; $----$ Dumping data for table $`$change$\_$requests$`--$ INSERT INTO $`$change$\_$requests$`(`$requestID$`,`$scheduleID$`,`$newDate$`,`$newTime$`,`$lecturerID$`,`$requestDate$`,`$requestStatus$`)$ VALUES $(3,2,\text{'}2024-12-14\text{'},\text{'}12$:$52$:$00\text{'},2,\text{'}2024-12-2308$:$50$:$17\text{'},$ 'rejected'$),(4,3,\text{'}2024-12-12\text{'},\text{'}15$:$58$:$00\text{'},1,\text{'}2024-12-2308$:$57$:$00\text{'},$ 'accepted'$)$; $--------------------------------------------------------------$ Table structure for table $`$cheatingcases$`--$ CREATE TABLE $`$cheatingcases$`(`$caseID$`$ int$(11)$ NOT NULL, $`$studentID$`$ int$(11)$ NOT NULL, $`$cheatingCaseType$`$ varchar$(255)$ NOT NULL, $`$description$`$ text NOT NULL, $`$incident$\_$report$`$ text NOT NULL, $`$fileName$`$ varchar$(255)$ NOT NULL, $`$status$`$ varchar$(50)$ NOT NULL, $`$submissionDate$`$ timestamp NOT NULL DEFAULT current$\_$timestamp$())$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_$general$\_$ci; $----$ Dumping data for table $`$cheatingcases$`--$ INSERT INTO $`$cheatingcases$`(`$caseID$`,`$studentID$`,`$cheatingCaseType$`,`$description$`,`$incident$\_$report$`,`$fileName$`,`$status$`,`$submissionDate$`)$ VALUES $(2,3,$ 'Smartwatch', $\text{'}\text{'},\text{'}\text{'},\text{'}67685767$a$0576\_$PHOTO$-2024-12-04-19-23-05.$jpg$\text{'},$ 'Pending', $\text{'}2024-12-2218$:$16$:$07\text{'})$; $--------------------------------------------------------------$ Table structure for table $`$course$`--$ CREATE TABLE $`$course$`(`$courseID$`$ int$(11)$ NOT NULL, $`$courseCode$`$ varchar$(15)$ NOT NULL, $`$courseName$`$ varchar$(255)$ DEFAULT NULL, $`$coordinatorID$`$ int$(11)$ DEFAULT NULL, $`$departmentID$`$ int$(11)$ DEFAULT NULL $)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_$general$\_$ci; $----$ Dumping data for table $`$course$`--$ INSERT INTO $`$course$`(`$courseID$`,`$courseCode$`,`$courseName$`,`$coordinatorID$`,`$departmentID$`)$ VALUES $(1,$ 'ITDM$1782\text{'},$ 'Data Structures', $1,1),(2,$ 'ITSW$1110\text{'},$ 'Calculus I$\text{'},2,2),(3,$ 'ITDM$1220\text{'},$ 'Physics', $3,3)$; $--------------------------------------------------------------$ Table structure for table $`$courseregistration$`--$ CREATE TABLE $`$courseregistration$`(`$registrationID$`$ int$(11)$ NOT NULL, $`$studentID$`$ int$(11)$ DEFAULT NULL, $`$sectionID$`$ int$(11)$ DEFAULT NULL, $`$scheduleID$`$ int$(11)$ DEFAULT NULL $)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_$general$\_$ci; $----$ Dumping data for table $`$courseregistration$`--$ INSERT INTO $`$courseregistration$`(`$registrationID$`,`$studentID$`,`$sectionID$`,`$scheduleID$`)$ VALUES $(1,3,1,1),(2,3,2,2),(3,4,3,3),(4,4,1,1),(5,4,2,2)$; $--------------------------------------------------------------$ Table structure for table $`$coursesection$`--$ CREATE TABLE $`$coursesection$`(`$sectionID$`$ int$(11)$ NOT NULL, $`$lecturerID$`$ int$(11)$ DEFAULT NULL, $`$sectionNumber$`$ int$(11)$ DEFAULT NULL, $`$numOfStudents$`$ int$(11)$ DEFAULT NULL, $`$courseID$`$ int$(11)$ DEFAULT NULL $)$ ENGINE$=$InnoDB DEFAULT CHARSET$=$utf$8$mb$4$ COLLATE$=$utf$8$mb$4\_$general$\_$ci; $----$ Dumping data for table $`$coursesection$`--$ INSERT INTO $`$coursesection$`(`$sectionID$`,`$lecturerID$`,`$sectionNumber$`,`$numOfStudents$`, Step by Step Solution There are 3 Steps involved in it 1 Expert Approved Answer Step: 1 Unlock Question Has Been Solved by an Expert! Get step-by-step solutions from verified subject matter experts Step: 2 Unlock Step: 3 Unlock Students Have Also Explored These Related Programming Questions! Q: Please only answer if you know 100% and dont. Copy form past post it a wrong answer. Don't any other information all other data is just make it up there is no specific data Need to create ERD diagram... Q: CREATE ERD DIAGRAM - - Narrative / Requirements for a Swim Team Database Each swim team is made up of at least 1 0 swimmers. For each swimmer, database should include a swimmer s social security... Q: A bridal company called Lilacs would like a database for their clients and the weddings they coordinate. The weddings have the following details: wedding date, maximum budget, start time, an... Q: Create ERD Diagram with given information Oakland Universit Decision andInfomation Sciences MIS 300-Management Infomation Systems Winter 2017 Due: 3/14/2017 PROBLEMI. [200 Points] Conceptual Data... Q: VVWell Money is a database system which keeps track of the information about customers and bank accounts for the Well Money Bank. A centralized database will help to provide general accessibility to... Q: you can use paper and draw the ERD diagram or you can use Microsoft Word or PowerPoint to create ERD diagram. 3. Use the following business rules to create a Crow's foot ERD. Create necessary... Q: A new technology company would like to build a database to implement mobile money in Jamaica. The company would like to store information on clients who can be categorized as senders or receivers.... Q: Company ABC wants to update its existing database to track properties, hosts, rental transactions, bookings, transaction ratings, etc. The following are notes provided by the Company ABC: Each... Q: Please follow the first steps insteuctione. pls create erd diagram and connect the relationships! Will upvote, thanks :) SR Consulting (SRC) is a firm that creates custom software for its clients.... Q: Question 2: (10 Points) Local veterinarian storing the pet details and treatment as below. Your task this to migrate this excel sheet to database objects and store it in RDBMS. PET NAME PET TYPE PET... Q: Below is the comparative income statement data for Mariner, Inc. Prepare a comparative common-size income statement for Mariner, Inc. Mariner, Inc. Comparative Income Statement Years Ended December... Q: Use the following information from The Boeing Company's financial statements for the fiscal year ended December 31, 2021 to answer the next four questions. Assume Wages payable will be paid within a... Q: The Financial Modemization Act allowed banks to merge with insurance companies. True Fatse Q: Briefly describe the political and ideological context of the 1930s that made the global spread of the concentration camp possible. Previous Question Next Question Recommended Textbook More Books Human Centered And Error Resilient Systems Development Ifip Wg 13 2/13 5 Joint Working Conference 6th International Conference On Human Centered Authors: Cristian Bogdan ,Jan Gulliksen ,Stefan Sauer ,Peter Forbrig ,Marco Winckler ,Chris Johnson ,Philippe Palanque ,Regina Bernhaupt ,Filip Kis 1st Edition 331944901X, 978-3319449012 Ask a Question and Get Instant Help! Study Help Services Sitemap Fun Definitions Become Tutor Used Textbooks Study Help Categories Recent Questions Expert Questions Campus Wear Sell Your Books Company Info Security Copyrights Privacy Policy Terms & Conditions SolutionInn Fee Scholarship Online Quiz Give Feedback, Get Rewards Get In Touch About Us Contact Us Career Jobs FAQ Student Discount Campus Ambassador Secure Payment Download Our App © 2026 SolutionInn. All Rights Reserved $