CIS 484编程写作、辅导SQL编程语言编程

” CIS 484编程写作、辅导SQL编程语言编程CIS 484 Lab #1All Labs in this course will build off the prior one. This Lab consists of three parts each withtheir own Due Dates:Part 1: [ERD] Due August 31st by 9:00 a.m.Part 2: [UI Design] Due Sept 7th by 9:00 a.m.Part 3: [Working Software/Database] Due Sept 14th by 9:00 a.m.[All three parts are INDIVIDUAL assignments]RequirementsFor this lab, you will use ASP.net, C#, and MS SQL Server. All of the labs are designed in a waythat you will need to ask Questions of your client (your instructor). Part 1:Below is an incomplete relationship of the DB Tables needed for the Lab, as shown in Access.You need to normalize the tables (3nf) and eliminate redundancy. You will need more tablesthan these shown. You will need to design your DB ERD based on the client requirements thatare listed in the following section. You might need to elicit or clarify more about the clientsneeds from your Instructor for all three Lab parts. The Primary Keys for the two tables shownmust be an integer, and the next key value will be determined by the highest key value used. Youcan assume that at least one record already exists in each table.Your first deliverable (Part 1) is to create an ERD in something like Visio (or any other datamodeling software) using the above as a start and the below elicited requirements for details.You will submit your Visio ERD into Canvas by the deadline and have yours ready to discuss inClass (in-person or in WebEx) on 9/1/2020. Submit the deliverable to Canvas as a PDF. TheERD must include all the tables mentioned or hinted at below remember this will be your datamodel for your DB, and For the rest of your Labs! Make sure its realistic, normalized, andfunctionally sensible, And as complete as possible.CIS 484作业写作、辅导SQL编程语言作业Your second deliverable (Part 2) will be your layout for your User Interface. You will createthis with any electronic tool you wish. You will submit this to Canvas as a PDF (most likelyscreenshots or page-by-page of your design) and have yours ready to discuss in class on9/8/2020. Part 3Your third deliverable (Part 3) will be your completed program. This submission will includeyour Web Folder and your SQL (see details below) zipped up in one overall folder (see below).Your submission must allow me to create your tables and pre-populate them with your SQL(which much be correct and error-free) and allow me to run your Web Site, all without issues.Initially elicited requirements for the overall Lab:1. Students are attending smaller sub-events at a Field Trip-type outing at an educationalProgram event. Students can attend multiple events during the Program.2. Students will have a teacher from their Middle-School that will be the point of contactbetween the overall Program and them.3. The Program will Host a lunch, and teachers can sign their students up for this lunch, aswell as one or more events. The lunch can be considered an Event as well.4. The Program will have both coordinators and volunteers. Coordinators talk with theteachers and help them with any questions. Volunteers are active at the day-of Programduring each of the events. Each event will have at least 1 Volunteer, but a Volunteer cansign up for no More than 2 events.5. T-Shirts are given out to every participant in the Program (Coordinators, Volunteers,Teachers, and Students). T-Shirts include a logo and are in 4 colors: green, yellow, blue,and black. T-shirt sizes are collected from all participants.6. Events will have a date and time associated with them.Functionality, Programming, UI, and DB requirements for the Overall Lab:1. You will need to create a Student class that includes an array of Student objects. Allinserting of Student records into the DB will use this class. No I/O or SQL statementswill be included in the code for this class.2. You will need to Create an Event class that includes an array of Event objects. Allinserting of Event records into the DB will use this class. No I/O or SQL statements willbe included in the code for this class. Any other tables you create must also includeassociated classes for inserting in your DB for that table/class, and arrays for thoseclasses as well.3. Create any other classes as needed.4. Your program should not delete any information in any tables. You will use primary andforeign keys for your associations between tables, and create any bridge tables asnecessary.5. You should not use an SQL Create or Drop statement anywhere in the code for yourprogram. All SQL table creation should be done prior to your program running. You willinclude a copy of this SQL code in your Canvas submission for Part 3.6. Your program should allow for the creation of Students and the insertion of associatedrecords into the DB. The UI should accommodate the entering of info and creation ofStudents. You should pre-populate some test records (at least 3-5 include the SQL forthis in your submission) for all other tables/entities (Events, Teachers, etc.) and yourprogram in Lab 1 does not have to have the ability to create these, BUT it should have theability to associate these and Student records. For example once Ive used yourprogram to create some Students, I should be able to associate them with a Teacher andsign them up with to an event during the Program.7. Prior to insertion of new Student records into the Student class array, your programshould check to see if a record already exists. If it does, a message should appear to theuser and the text boxes stay populated with what they typed in.8. Insertions of new Student records should go into the Student class array first. When theprogram loads, it should read all records from the DB for other tables, create theirinstance objects, and reference them from the associated Class arrays (Remember thatwe will only be creating New Student records from the UI). A Commit button should bepresent somewhere in your UI to write out the Student data from its Class array to theDB. Be sure to perform the same check: if the student record represented by the Object isalready in the DB, Dont write it out (no duplicate records).9. For testing purposes, include a Populate button that will fill textboxes with valid data.10. Also include a Clear button so that all the textboxes can be cleared out.11. Make sure your data is Validated (using our ASP.net and C# data validation techniques)and use Try/Catch as needed.12. Your name should appear in the title of your webpage application and in the comments ofyour files, and in the main body of your Form.13. Your SQL Server DataBase must be called Lab1 and the server must be LocalHost /MSSQLSERVER (the default SQL Server service that installs).Submission Requirements Your program must have no error or informational compile errors or warnings. I will judge your programs based on how well they work and on the elegance of the code.Code should be well documented and efficient. Proper indentation, descriptive variablenames, and comments are essential. No extraneous variables or extra unnecessary lines ofcode. All files must include your name at the top of the code listing. Zip your Web Site folder and submit that to canvas, along with your SQL listings in atext file (include this in the zip Place your Web Folder and text files in an overall folderand zip that).Grading Rubric:Your name is in the title and body of the webpage 1 PointStudent Class file: in its own file, all (data) fields are private, no sql in the classfile.1 PointsDrop Down List shows Current, live list of students to associate with teachers,events, etc.1 PointPopulate button to populate textboxes with valid information for testing. 1 PointValidation: Your form does not process when some or none of the textboxes areblank.1 PointValidation: Verify that a Volunteer cannot sign up for more than 2 events. 1 PointCreation of Students go into that Class array first. No duplicates are allowed.ArrayList cannot be used (use a static array).1 PointCommit button functions, inserts student records into the DB from the Classarray, no duplicates occur.5 PointsClear button functions as required 1 PointCode is properly indented, commented, intuitive variable names used,efficiently coded.3 PointsProgram runs with no Errors/issues. SQL is error free and correct (so that I canrun it on my local machine)4 PointsAssociations Between entities can occur (students with teachers, teachers withschools, students with events, volunteers with events, coordinators withvolunteers, etc.)5 PointsTotal: 20 Points如有需要，请加QQ：99515681 或邮箱：99515681@qq.com

“