Hendela, Arthur

English

Digital Commons @ New Jersey Institute of Technology (NJIT)

New Jersey Institute of Technology Digital Commons @ NJIT Informatics Syllabi NJIT Syllabi Fall 2023 IS 331 - 001: Database Design, Management and Applications Database Design, Management and Applications Arthur Hendela Follow this and additional works at: https://digitalcommons.njit.edu/info-syllabi Recommended Citation Hendela, Arthur, "IS 331 - 001: Database Design, Management and Applications Database Design, Management and Applications" (2023). Informatics Syllabi. 218. https://digitalcommons.njit.edu/info-syllabi/218 This Syllabus is brought to you for free and open access by the NJIT Syllabi at Digital Commons @ NJIT. It has been accepted for inclusion in Informatics Syllabi by an authorized administrator of Digital Commons @ NJIT. For more information, please contact digitalcommons@njit.edu. Course SyllabusIS 331-001 FALL 2023Database Design, Management and ApplicationsClass Time: Monday 1:00 PM – 2:20 PM (CKB 219)                   Tuesday 1:00 PM – 2:20 PM (KUPF 105)Location: LiveInstructor Information:Name: Dr. Art HendelaOffice: 3809 GITCPhone Number: 973-596-5841Email (preferred): ahh2@njit.eduOffice Hours:Monday: 4:00 PM-4:50 PM (By Appointment only)Tuesday: 4:00 PM-4:50 PM Thursday: 11:30 AM-12:30 PM   TextbookREQUIRED: Kroenke and D. Auer, S. Vandenbrg, R.Yoder, DATABASE CONCEPTS, 10thEdition, Pearson, 2022.ISBN: 978-013-791678-8REQUIRED: Syverson, Bryan and Joel Murach, SQL Server 2022 for Developers, Mike Murachand Associates, 2023. ISBN: 978-1-943873-06-7Hardware RequiredWindows-based computer. If you do not have one, then you must use the computers available oncampus.Software (Required for installation on your personal machine or used in NJIT ComputerLabs)● Microsoft Access● Microsoft Excel● Microsoft Visio● Microsoft SQL Server 2022. Mac users may have to use the version in a virtual machine.● Microsoft SQL Server Management Studio● Virtual machine software if you are using a Mac● Repondus Lockdown browser and webcamCourse DescriptionBusinesses use databases extensively for analysis and decision-making because they provideefficient, large-scale information storage and rapid retrieval. Databases support the "back endfunctionality" of most large web systems. This course gives students extensive, pragmaticexperience in designing, building, querying, updating, maintaining and managing relationaldatabases, using the Structured Query Language (SQL). Proper database design principles areemphasized throughout the course, beginning with high level descriptions of relational databasesusing data modeling tools(such as entity-relationship or ER diagrams)and progressing torelational database design principles based on higher order normalizations. We will examinesome poorly designed databases and show how these can be transformed into well designeddatabases. SQL will be extensively covered, and students will design implement sophisticatedSQL queries invoking self-joins, outer joins, correlated sub-queries and related concepts.Students will explore and utilize design methodologies for input data validation and maintainingdatabase integrity, and study issues of database privacy and security. Advanced topics to bediscussed include the role of the Database Administrator (DBA), database life cycle activities,database de-normalization, read-only database and data warehouses. Hands-on experience willbe gained by with actual database using industry-standard database management systems such asOracle.PrerequisiteCompletion IS218, Building Web Applications or IT202, Internet and Applications. It isalso assumed that students have some basic familiarity with Microsoft Office, particularlyMicrosoft Access.Class Communication Space/Learning Management SystemWe will be using Canvas, an open source Learning Management System at NJIT, for the postingof projects and class resources and other class announcements are postings. Students havingquestions on projects, etc., may contact Dr. Hendela directly at ahh2@njit.edu or, if the answerwould benefit the class, post the question in the appropriate forum within Canvas. Students areobligated to log into Canvas on a near-daily basis, and to keep current. DO NOT use the CanvasMessage feature. It does not give your name or class section. I cannot respond to these messages.Email me instead.Course Goals To understand the design and development issues regarding databases. Students will obtain astrong conceptual foundation of the underpinnings of database design, as well as gain experiencewith some commercial database management products, such as SQL Server. IS331 seeks toprovide the student with the conceptual and practical aspects and issues related to designing,implementing, managing, deploying, and utilizing database applications. The main emphasis ison the student’s comprehension of key concepts in database design as opposed to programmingor algorithms. The student will utilizes various DBMS products and software tools, includingSQL Server and SQL Server Management Studio, to put into practice the database conceptspresented. Lecture NotesPresentation slides will be downloadable each week from Canvas.Course Grade Components● Midterm Exam - 29%● Final Exam - 29%● Database conceptual assignments and DBMS projects (30%) – 8 throughout semester● Work participation / attendance 12%. The proportion of the assignments handed in willmostly determine your work participation grade. Grade Cutoffs● A: 90 - 100● B+ 86 - 89● B: 80 - 85● C+: 76-79● C: 70 - 75● D: 60 - 69● F: Below 60 Work Participation and AttendanceAttendance will be taken for each class meeting and is important for you to gain the most fromthis course. This course is offered face to face in order for you to gain the most understanding ofthe material and to be able to ask questions in real-time. For cases where you miss less than 4classes, attendance will be used to determine the higher or lower of two grades when you arebetween grade cutoffs such as above 85 but not fully 86. The more classes you attend, the betterchance you have of gaining the higher grade.Work Participation is worth 12% of your final grade. Many people, including the coursecoordinator worked for a long time as a consultant that was home-based. Customers only knewme from the work I handed to them on time. My customers did not accept excuses for late work.In order to better prepare you for the many work places which work on a results basis withflexible hours and attendance policies, I put the weight of this grade into your results, not justsitting in a seat. That said, if you have a life situation that needs to be taken into account for yourperformance, please see me. Medical excuses must go through the Dean of Students office.Any missing homework assignments, A01-A08, go against your work participation grade.Missed homework assignments not only get a zero for the assignment but also a lowering of yourwork participation grade. This is also true for assignments that score a zero for any other reason.This is how I calculate your participation grade:(Number of assignments attempted with grade above 0) / Number of total assignments * 12)With this formula, the proportion of the work you factually attempt is considered yourparticipation. Do not miss assignments. They must be on time or no credit is given. Late Project PolicyAll projects and assignments must be turned in on time, or no credit is given unless an exceptiongranted by extraordinary circumstances verified by the Dean of Students..Extra Credit PolicyThere is no extra credit assignments given. You do the assigned work at the time it is given andsubmit it on time for a grade.Make Up PolicyThere are no make ups for missed assignments or exams. The grade is entered as Zero unless anexception granted by extraordinary circumstances verified by the Dean of Students.Absence PolicyYou are expected to attend every class if you will not attend a class you should notify me thatyou will not be attending. MISSING 4 OR MORE CLASSES WILL LOWER YOURFINAL GRADE BY ONE LETTER GRADE FOR EACH 4 CLASSES YOU MISS. YOUMUST SIGN YOURSELF IN ON THE ATTENDANCE SHEET TO BE COUNTED. IT ISYOUR RESPONSIBILITY TO MAKE SURE YOU ARE SIGNED IN. SIGNINGSOMEONE ELSE IN IS COUNTED AS CHEATING. SEE ACADEMIC INTEGRITYPOLICY FOR PENALTY.Medical Excuses need to be reported to the Dean of Students and they will decide if it is to beexcused or not.Academic Integrity PolicyAcademic Integrity is the cornerstone of higher education and is central to the ideals of thiscourse and the university. Cheating is strictly prohibited and devalues the degree that you areworking on. As a member of the NJIT community, it is your responsibility to protect youreducational investment by knowing and following the academic code of integrity policy that isfound at: http://www5.njit.edu/policies/sites/policies/files/academic-integrity-code.pdfLinks to an external site..   Please note that it is my professional obligation and responsibility to report any academicmisconduct to the Dean of Students Office. Any student found in violation of the code bycheating, plagiarizing or using any online software inappropriately will result in disciplinaryaction. This may include a failing grade of F, and/or suspension or dismissal from theuniversity. If you have any questions about the code of Academic Integrity, please contact theDean of Students Office at dos@njit.eduMy expectation is that each person will complete original work for this course and will not copyfrom fellow students or tutorials online. It is OK to refer to tutorials online; however, you will beconsidered in violation of the NJIT honor code by submitting work found online. Any violationsof the honor code will be referred to the Dean of Students for investigation and possibledisciplinary action.Every assignment/project is a 'home-mini-exam.' The NJIT Honor Code will be strictly upheld.Students found cheating/collaborating/plagiarizing will be immediately referred to the Dean ofStudents and the NJIT Committee on Professional Conduct and subject to possible DisciplinaryProbation, a permanent marking on the record, possible dismissal and a grade of 'F' in the course.All submitted assignments are carefully checked for similarities, and plagiarism and guiltystudents will be identified and referred to the Dean of Students for disciplinary action.Use of file sharing sites such are CourseHero.com is strictly forbidden. Students either posting orusing these sites will be referred to the Dean of Students for disciplinary action and/or copyrightinfringement prosecution. Additionally, DO NOT share files among yourselves. If you need help,ask me for it. DO NOT share your laptops or any of your files from this semester or from anyone that hastaken this course before. If your machine breaks, use the ones on campus in the PC Mall.This is your only warning. Cheating is not worth it - you may not only fail this course, but alsobe suspended or expelled from NJIT. THE INSTRUCTOR RESERVES THE RIGHT TOREQUIRE REMOTE EXAM PROCTORING SOFTWARE SUCH AS RESPONDUS.For more information about the NJIT honor code, you should refer to this document:http://www.njit.edu/doss/code-student-conduct-article-11-university-policy-academic-integrity/Links to an external site. General PolicyAssignments and exams are to be completed with assignments uploaded to Canvas by the duedates. You must have a very good reason for requesting an extension—email your request to theinstructor well before the due date. Exceptions are granted under extraordinary circumstancesverified by the Dean of Students.TopicsBelow are the topics covered in the course and the related textbook readings. The key to successin IS331 is your own self-discipline. Keep up with the work and readings and do not fall behind.Catching up is nearly impossible. I want you to develop the self-discipline to succeed not only inthis class, but also in your future careers.  WEEK TOPICS BOOK READINGS HOMEWORK1 Welcome & Intro  Assignment 12File processing systemsDatabase IntroChapter 1M:Chapter 1Assignment 23Conceptual Design 1Conceptual Design 2Chapter 1M:Chapter 10Assignment 34Conceptual Design 3Conceptual Design 4Chapter 2 Assignment 45Logical Design 1Logical Design 2Chapter 5M: Chapter 10 6Logical Design 3 Chapter 4Assignment 5Assignment 67Logical Design 4Physical DesignChapter 4M: Chapter 8 8 Midterm Exam  Online or Inperson atProfessor’sdiscretion.Online examwill requireResponduslockdownbrowser andwebcam.9Data Definition LanguageData Definition Language LabChapter 3M:Chapter 9 & 11 10Relational Algebra 1Relational Algebra 2Chapter 6M: Chapter 3, 4 11Relational Algebra 3Relational Algebra 4Chapter 6M: Chapter 5, 6 12SQL PracticeSQL Management StudioM:Chapter 2, 7, & 12 Assignment 713PL SQL, TSQLCreating Views and other objectsM: Chapter 13, 14, 15, 17  14Transaction ProcessingData WarehousingChapter 7M: Chapter 16Assignment 815 Final Examination In ClassIn person oronline atProfessor’sdiscretion.Online examwill requireResponduslockdownbrowser andwebcam.16 Grades due at Registrar     Course Outcomes for IS331● Course outcome 1: The student can demonstrate the use of SQL to properly andoptimally design and implement a database from a set of user requirements, ensuringdata integrity, and providing a high level description of the database, using EntityRelationship Data Modeling. (Assignment A04)● Course outcome 2: The student will transform a conceptual database design, into alogical set of relations that can be used as a basis for a physical implementation. Thestudent will apply the principles of relational database design such as referential integrity,normalization, and relationships. (Assignment A06)● Course outcome 3: The student is able to construct sophisticated SQL queries, usingadvanced SQL topics such including self-join, inner and outer joins, and other types ofqueries. (Assignment A08) Student OutcomesStudent outcomes versus course outcomes. Student Outcomes Addressed bySO 1 Analyze a complex computing problem and to applyprinciples of computing and other relevant disciplines toidentify solutions(CO1-A04),(CO2-A06),(CO3-A08)SO 2 Design, implement, and evaluate a computing-basedsolution to meet a given set of computing requirements inthe context of the program’s discipline(CO1-A04),(CO2-A06)SO 3 Communicate effectively in a variety of professionalcontexts  SO 4 Recognize professional responsibilities and makeinformed judgments in computing practice based on legaland ethical principles SO 5 Function effectively as a member or leader of a teamengaged in activities appropriate to the program’s discipline  SO 6 Support the delivery, use, and management ofinformation systems within an information systemsenvironment(CO1-A04),(CO3-A08) NOTE: Numbers in the “Addressed by” column refer to the numbers in the “Student OutcomesAfter Completing IS331” section above.   Topics to be Covered 1. Properties of databases2. Flat-file databases vs. relational databases3. High-level descriptions of databases using Entity-Relationship Diagrams with Chen andCrow’s Foot Nomenclature4. Translation of ER Models to Relational Designs5. Methodologies for querying a database, including Relational Algebra operators andgraphical query interfaces such as GQBE6. Fundamental syntax of SQL, creating a database with SQL7. Examination of some poorly designed databases and rectifying their design8. Responsibilities of the database professional, including issues of database integrity andethical obligations involving privacy/security of data9. Functional dependencies and multi-valued dependencies10. Optimal database design using Normalization (1NF, 2NF, 3NF, BCNF, 4NF, DKNF)11. De-normalization and when it should be used.12. Use of update-able vs. read-only databases13. Referential integrity, foreign key constraints, and casual relationships14. Data warehouses and their high level design15. Advanced SQL query design using, for example, self, inner, outer, left and right joins16. Input validation and database integrity17. Methods for database redesign18. Use of correlated and non-correlated sub-queriesCourse Summary:Date Details DueTue Sep19, 2023Discussion Topic A01. Assignment 1 Introduce yourself / Pick StockSymbol / Create Code Academy Accountdue by11:59pmTue Oct3, 2023 Assignment A02. Assignment 2 submission and Instructionsdue by11:59pmTue Oct10, 2023 Assignment A03. Assignment 3 submissiondue by11:59pmTue Oct24, 2023 Assignment A04. Assignment 4 submission (as of 01/02/2023)due by11:59pmTue Oct31, 2023Quiz IS331 Fall 2023 Midterm Quiz - Online-Covers Lectures, KroenkeChapters 1,2,4, & 5, Murach Chapters 1, 8, and 10 plusAssignments-Requires Respondus LockDown Browser + Webcamdue by2:20pmWed Nov1, 2023 Assignment A05. Submit Completed SQL Code Academy Linkdue by11:59pmTue Nov7, 2023 Assignment A06. Assignment 6 submissiondue by11:59pmTue Nov14, 2023 Assignment A07. Assignment 7 submissionsdue by11:59pmTue Dec5, 2023 Assignment A08. Assignment 8 submissionsdue by11:59pmTue Dec12, 2023Quiz IS331 Fall 2023 Final Quiz - Online - Covers Lectures, KroenkeChapters 6,7, Murach Chapters 2,3,4,5,6, 7, 11,12,13,14,15,16 plusAssignments- Requires Respondus LockDown Browser + Webcamdue by2:20pmQuiz Respondus Test Quiz - Requires Respondus LockDown Browser +Webcam  Assignment Work Participation  

IS 331 - 001: Database Design, Management and Applications
Database Design, Management and Applications

https://digitalcommons.njit.edu/cgi/viewcontent.cgi?article=1217&context=info-syllabi

IS 331 - 001: Database Design, Management and Applications Database Design, Management and Applications

Abstract

Similar works

Full text

Available Versions

Digital Commons @ New Jersey Institute of Technology (NJIT)