Database Programming Project Proposals

1 Database Programming Project ProposalsZhizhang Shen Dept. of Computer Science and TechnologyPlymouth State UniversityAugust 26, 2022 AbstractThis is Part III of the lab notes prepared for the students ofCS3600 Introductionto the Database Systemsfor Fall present a few ideas, with consistent level of challenge, which you can use todevelop your Project proposal for this Project worths fifteen points. We also give some specificcriteria and guideline,in 4, as how the students will be graded for the outcome in completing this The rule of the game22 Project Video Chain Database .. Library Management System.

2 A Music Store Database .. University Student Database .. Department Management Database .. Grade Book Database .. 93 What to hand Grading criteria11 Address correspondence toDr. Zhizhang Shen, Dept. of Computer Science and Technology, PlymouthState University, Plymouth, NH 03264, The rule of the gameYou will learn lots of Database related concepts and skills throughout this course. But,Application is the apply some of the stuff as we have been learning in this course,and to develop some habits of team work, the key ingredients of carrying out databaseprojects, the class will be cut into a few Project teams, with3 to 4 students.

3 Each team willelect a Project leader, come up with a Project proposal , a rough schedule, and complete theproject by the end of this semester. The Project group will then make a presentation to thewhole class at the end of the principle, all the members of the same team will be assigned the same grade. All themembers of a team are expected to make a reasonable contribution, and the team leader willmake a report about what each and every team member has done, which will be taken intoconsideration when a grade is Project proposalsWe list six Proposals in the following. Some of them are adapted based on some ideas ascontained in [2].

4 A Project team can certainly come up with their own non-trivial proposal , consistentwith these sample Video Chain DatabaseThis was essentially a management system for a chain of videostores. Most of such stores,such asBlockbuster, now part of theDISH, have been struggling, but the Database com-ponent is certainly useful, and its ideas can be applied key is that those stores might share the same inventory, but each store has its ownrental records, and employee records. Thus, such a databaseshould contain informationaboutStores, Employees, Movies, Members, Rentals, group should go through the following steps in completing this Project :1.

5 Describe some realistic constraints for this Project , both business rules, , no videocannot be rented out if no copy remains; and non-business rules, such as primary keys,foreign keys, check constraints, andnot nullconstraints, for the tables and attributes, Design the Database , following an E/R approach; then go through the normalizationprocess to come up with a collection of tables that are in Boyce-Codd normal team has to include the original design in terms of E/R diagrams and paper workto show the normalization process in the final team has to include arequirement documentin the form of the one as discussedin [1, ]

6 , a preliminary analysis and a list of final UseMariaDBto create the normalized team has to come up with a list of print-outs of the table structure and the content,similar to those as contained in the lab Do a research on how the most recent version ofMariaDBimplements the concept oftriggersand then create appropriate triggers for your Database . to maintain integrityof the Database and to perform appropriate actions on Database example, one possible trigger could be placed and then acted uponafterthe lastcopy of a movie is being rented team has to come up with a list of issues,and a discussion as whether an issuecan be resolved with a trigger,before, afterorinstead.

7 And why it is not Populate the Database by usingMariaDBstatements, or with some GUI interface Develop a collection of at least ten non-trivial and application oriented queries and/ortriggers, addressing users s needs, and a correct implementation Write an interface inHTML,with embeddedPhPscript(s). The main interface shouldcontain aMainmenu, includingMember functions, Administrative functions,andRe-porting functions. Implement thepassword securitymechanism as described in Section in thePhPNotes. TheMemberpage should include such functions asCheck out, New member sign-up, list of videos for a member that have yet to be returned,andMembershipcancellation.

8 Theadministrativepage should include such functions asadd/delete employees,buy new tapes, ,as well asopen new stores, Thereportpage should include such features asprint the whole catalog, print adue list of tapes, print the employee list, print rental summary(ordered by rentalfrequency, You should certainly add in your own queries in appropriate places in the group should include in the final documentation a list of questions a user of thissystem might want to ask, together with a list ofMariaDBqueries that help to Document the Project , containing at least the pieces as pointed out in the Library Management SystemThis is supposed to develop a Database system for the local library.)

9 Your finished productshould contain information aboutbooks, book authors, publishers, employees, ILLs, group should go through the following steps in completing this Project :1. Describe some realistic constraints, including business related, , one person can onlycheck out five books a time; and business related ones, such asprimary keys, foreignkeys, check constraints, andnot nullconstraints, for the tables and attributes, Design the Database , following an E/R approach; then go through the normalizationprocess to come up with a collection of tables that are in Boyce-Codd normal team has to include the original design in terms of E/R diagrams and paper workto show the normalization process in the final team has to include arequirement documentin the form of the one as discussedin [1, ]

10 , a preliminary analysis and a list of final UseMariaDBto create the normalized team has to come up with a list of print-outs of the table structure and the content,similar to those as contained in the lab Do a research on how the most recent version ofMariaDBimplements the concept oftriggersand then create appropriate triggers for your Database . to maintain integrityof the Database and to perform appropriate actions on Database example, One of suchbeforetriggers could be that someone wants to check out abook on how to build bombsThe team has to come up with a list of issues,and a discussion as whether an issuecan be resolved with a trigger,before, afterorinstead.