Project: Design a personal or business-related database that would be of interest to you Using Oracle. Some examples might include: Accounting Investment management Payroll Volunteer activities Dentist/doctor office .Cookbook/recipes Collections (records, movies, baseball cards) The project involves collecting the application requirements, designing the database, specifying which operations will be supported on the data, and building the database. The project will be evaluated based on: 1. Creativity of the database, 2. Amount of the course material applied to the project, 3. Complexity of relationships and constraints among objects, 4. Complexity of queries over the data, and 5. Completeness of testing of DB. Due: Week 6 Description of DB: Why should your database be built? You need to discuss these elements: 1. What tasks, operations or processes the system supports, and what user group or groups are served 2. Limitations of your system (any system has it, and so does yours; a candid statement on system limitations is an indispensable part of a good system development practice) .Database schema (the layout of normalized and linked tables, this can be submitted in any type of file you want (doc, txt, vsd) if the grader can read the file. You may submit more than one file). Project: Design a personal or business-related database that would be of interest to you Using Oracle. Some examples might include: Accounting Investment management Payroll Volunteer activities Dentist/doctor office .Cookbook/recipes Collections (records, movies, baseball cards) The project involves collecting the application requirements, designing the database, specifying which operations will be supported on the data, and building the database. The project will be evaluated based on: 1. Creativity of the database, 2. Amount of the course material applied to the project, 3. Complexity of relationships and constraints among objects, 4. Complexity of queries over the data, and 5. Completeness of testing of DB. Due: Week 6 Description of DB: Why should your database be built? You need to discuss these elements: 1. What tasks, operations or processes the system supports, and what user group or groups are served 2. Limitations of your system (any system has it, and so does yours; a candid statement on system limitations is an indispensable part of a good system development practice) .Database schema (the layout of normalized and linked tables, this can be submitted in any type of file you want (doc, txt, vsd) if the grader can read the file. You may submit more than one file)
