Database Design Project Proposal Review The Final Project

Database Design Project Proposal Review the Final Project Description below and begin to plan your database design

De Neys W 2006 Dual Processing In Reasoning Two Systems But One De Neys W 2006 Dual Processing In Reasoning Two Systems But One De Neys, W. (2006). Dual processing in reasoning: Two systems but one reasoner. Psychological Science, 17, . Drew, T., Vàµ, M., & Wolfe, J. (2013). The Invisible Gorilla Strikes Again. Psychological Science, 24 (9), . Ferriera, M.B., Garcia-Marques, L., Sherman, S.J., & Sherman, J.W. (2006). Automatic and controlled components of judgment and decision making. Journal of Personality & Social Psychology, 91, Finucane, M.L., Alhakami, A., Slovic, P., & Johnson, S.M. (2000) The affect heuristic in judgments of risks and benefits. Journal of Behavioral Decision Making, 13 , 1-17. Fong, G., Krantz, D., & Nisbett, R. (1986). The effects of statistical training on thinking about everyday problems. Cognitive Psychology, 18, . Fong, G., & Nisbett, R. (1991), Immediate and delayed transfer of training effects in statistical reasoning. Journal of Experimental Psychology: General, 120, 34-45. Hamill, R., Wilson, T.D., & Nisbett, R.E. (1980). Insensitivity to sample bias: Generalizing from atypical cases. Journal of Personality and Social Psychology, 39, . Kahneman, D., (2011). Thinking, fast and slow . New York, NY: Farrar, Straus and Giroux. Kahneman, D., & Klein, G. (2009). Conditions for intuitive expertise: A failure to disagree. American Psychologist, 64, Masicampo, E., & Baumeister, R. (2008). Toward a Physiology of Dual-Process Reasoning and Judgment: Lemonade, Willpower, and Expensive Rule-Based Analysis. Psychological Science, 19 (3), . Stanovich, K.E., & West, R. (1998). Cognitive Ability and Variation in Selection Task Performance. Thinking & Reasoning, 4 (3), . Todd, P.M, & Gigerenzer, G. (2007). Environments that make us smart. Current Directions in Psychological Science, 16, . Tversky, A., & Kahneman, D. (1973). Availability: A heuristic for judging frequency and probability. Cognitive Psychology, 5, . Tversky, A. & Kahneman, D (1974). Judgments under uncertainty: Heuristics and biases. Science, 185 , Database Design Project Proposal Review the Final Project Description below and begin to plan your database design. The first step to any database design is to determine its purpose and to define how it will be used. This week, you must submit your Database Design Project Proposal that explains what kind of database you will design, the type of information your database will contain, and the type of information output for your database. Use the following questions to guide you as you plan the needs and features for your database. 1. What is the purpose of the database? Why is it needed? What should it do? 2. Who are the users and what are their information needs? 3. What are the questions that the system should answer? 4. What type of input data is going to be available to the database? 5. What kind of information should be stored in the database? Then, write a one-page, proposal that addresses the following: A description of the problem domain (written using terminology that a user of the system would use; no need for technical database terminology.) Choose a domain with which you are familiar. Your domain should be different than examples provided in the textbook and in class. Identify a set of requirements for a system that is appropriate for your domain. If you wish, you may choose an appropriate sub-set of a larger domain. Final Project Description Final project is to develop a database from the ground up, including the conceptual modeling design, entity relationship diagram (ERD), logical modeling design, relational schema, physical modeling design, Structured Query Language (SQL), Database Management Systems (DBMS), and implementing the DBMS. Your project should be original work. Any outside sources should be cited in an APA-style reference page. The Gangwish Library Online provides excellent sources. Examples for your final project Human Resources (HR) Employee Management System: This system allows HR staff to manage information about each hired employee. Information Services (IT) Asset Management System: This element allows the IT staff to maintain information about the computer hardware, software, and peripherals owned by the organization. Departmental Intranet Management System: This system allows a liaison from each department to update the individual departmental information page. This reduces the need for IT staff to make updates to the intranet every time a department makes a change. College Database Project: A college contains many departments that each offer any number of courses. Each department employs many instructors, but an instructor can only work in one department. Hospital Management System: A full description of the personal patient detail, phone number, and updated health history records. The doctor handles patients, and one doctor can treat more than one patient. Each doctor has a unique ID. Doctor and patients are related. Patients can be admitted to the hospital and are assigned a hospital room. There are patient rooms, operation theaters, and ICU rooms in the hospital. Hotel Management System: A hotel is a hive of numerous operations including, front office, booking and reservation, banquet, finance, HR, inventory, material management, quality management, security, energy management, housekeeping, customer relationship management (CRM), and more. The hotel has different categories of rooms that each have different prices. Some hotel employees manage the services offered to customers. The customer can book a room either online or by cash payment at the hotel. Rubric for research paper: _______ Introductory paragraph and thesis statement provided (10 points) _______ Main ideas and subpoints are evident; the flow of the paper is logical; the paper is clearly organized according to the main points (20 points) _______ Scientific evidence (from peer-reviewed research studies) is given to support main ideas and subpoints (30 points) _______ Sources are cited in APA format; references are provided in APA format (15 points) _______ Tone and word choice are appropriate for an academic paper; scientific language is used; the writing is clear (15 points) _______ There are no errors in spelling or grammar (10 points) _______ Total (out of 100 points) Grammar, spelling, and style: Your papers should read like a review paper from a peer-reviewed journal. You will find a .pdf on D2L entitled “Writing in Psychology.” Please read this! Below is a brief list of some of the principles to follow when writing your paper. · Please use spell check and grammar check – points are deducted for errors. Do not use contractions (e.g., “it does not” rather than “it doesn’t”). · Please put section titles throughout your paper - it makes it easier to read. Use subtitles to indicate clearly each section of the paper; for example, title the first paragraph “Introduction” · Thesis statements should be clear – be sure you begin each sections and each paragraphs with statement of the main point of the section or paragraph · Learning to use the appropriate tone in an academic paper can be challenging. The best examples are the Introduction sections from peer-reviewed papers. To get into the right "headspace" for academic writing, try reading the abstracts and introductions from a few of your sources. · Leave out any personal information (both as content or in your writing style) and focus on research findings. · As a guideline, minimize using first person (e.g., “this study was conducted…” rather than “we conducted this study…” or say “This paper addresses…” rather than “I will address…”).

Paper For Above instruction

The purpose of this paper is to create a detailed and comprehensive database design proposal that encompasses the entire process from conceptualization to implementation. The primary goal is to develop a system that efficiently manages information within a specific domain, addressing the needs identified by prospective users. Effective database design is essential for streamlining data management, improving data accuracy, and facilitating easy retrieval of information to support decision-making processes. This proposal will first define the purpose and scope of the database, identify the target users and their needs, outline the key questions the system should answer, and specify the types of input and stored data. The chosen domain for this project is a library management system, tailored to meet the needs of an academic library. The library system is vital for managing resources such as books, journals, e-books, DVDs, and other media, as well as tracking member information, staff roles, and borrowing activities. The primary users include library staff, students, faculty, and administrative personnel who require accurate, up-to-date information on available resources, borrowing statuses, and overdue items. The system must answer questions such as what materials are available, who has borrowed which items, when items are due, and fines or penalties incurred. Input data includes new resource acquisitions, user registration details, borrowing and return transactions, and overdue notifications. The system should store details such as titles, authors, publication years, resource types, user profiles, borrowing dates, due dates, and fines. The requirements for the system include a user-friendly interface, secure access controls, robust data retrieval capabilities, and reporting functions. These features aim to improve operational efficiency and enhance user experience. The system's output should include reports on borrowed items, overdue notices, resource availability, and user activity logs. This structured approach ensures the database will serve the needs of the library effectively, supporting daily operations and strategic planning. In conclusion, designing a comprehensive library management database involves careful planning and understanding of user requirements, data types, and system functionalities. The process from conceptual modeling to implementation helps ensure the database will be scalable, secure, and capable of supporting the library’s mission to provide access to its resources efficiently and effectively.

References

• Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th ed.). Pearson.