...“Petilla Dormitory” Sampaloc, Manila A Case Study in Database Design Partial Fulfillment of the Requirements in Database Lecture Bachelor of Science in Information System Submitted by: FRANCIA, Jan Diether GISALA, Aaron MORALES, Shiela May C. NOARIN, Jenny M. October 2015 Table of Contents Title page ------------------------------------------------------------------------ I I. Overview A. Company Profile ------------------------------------------------------------- 1 B. Sample Forms --------------------------------------------------------------- 2 II. Database Planning A. Mission Statement ----------------------------------------------------------- 3 B. Mission Objectives ----------------------------------------------------------- 3 C. Project Team and Responsibility Assignment ------------------------------ 4 III. Database Boundary A. System Boundary ------------------------------------------------------------ 5 B. Database User --------------------------------------------------------------- 6 C. Data Dictionary -------------------------------------------------------------- 7 IV. Requirements Collection and Analysis A. Database Normalization ---------------------------------------------------- 14 V. System Specification A. System Specification ------------------------------------------------------- 15 VI. Physical Database Design A. Physical Database Design -------------------------------------------------- 16 ...
Words: 2260 - Pages: 10
...The database development Process Vamsinadh Machavarapu IST 7000 Wilmington University Table Of Contents Introduction...........................................................................................3 SDLC Phases.........................................................................................3 • Requirements Analysis...................................................................4 • Database Design.............................................................................4 • Evaluation and Selection................................................................5 • Logical Database design................................................................5 • Physical Database design...............................................................6 • Implementation..............................................................................6 • Data Loading.................................................................................7 • Testing and Performance Tuning...................................................7 • Operation.......................................................................................7 • Maintenance...................................................................................8 Conclusion.............................................................................................8 References.......................................................................................
Words: 1225 - Pages: 5
...Logical Design and Physical Design CMGT 555/ Systems Analysis and Development Throughout the whole process of system development, there are designs that take place before any coding or setup takes place. During this time, phrases like logical design and physical design get tossed around a lot, but what are they and what do they mean? In short, the logical design defines what must take place, not how it is accomplished. The logical design is like a set of blue prints, it describes the actual processes of entering, verifying, and storing data. In this paper we will explain when logical designs and physical designs are used, what design information a logical design and physical design contain and any similarities or differences. Figure 1. Example of Logical Model and Physical Model for an ERD Relationship Diagram (Compare Logical and Physical ERD, 2009) The direct definition of a logical design “is the Conceptual Blueprint of a software application, illustrating entities, relationships, rules, and processes (Thibeault, 2011)”. So what is the logical design is used for? The logical design contains all the business entries, what each entries attributes are, and relationships among entries. Now the logical design to some is misleading because they often confuse it with detailed technical design, even though the goals for these two are not similar at all. Now when do we use the logical design? That question is simpler to answer; it usually starts during the requirements...
Words: 845 - Pages: 4
...DIALOGUE SALESPERSON INFORMATION 5 USER REQUIREMENTS DIAGRAM 8 Forms 8 Report 13 DATABASE DESIGN 18 ARCHITECTURE DESIGN 22 CONCLUSION……………………………………………………………………………………………24 INTRODUCTION In the System Development Life Cycle (SDLC), there are four phases that need to be done to develop a system for used of by the organization. The phases are system planning and selection, system analysis, system design and implementation and operation. Since the planning and analysis phase have successfully completed, now we are continue with the next phase, which is systems design of the POS System in ARZA Coffee & Cakes. System design under System Development Life Cycle was a conversion of description of the recommended alternative solution into logical and physical specifications for the system starting from the input until the output screens consists of report, databases and computer processes. By that action the company might ease to reveals the real systems from which all the programming and system construction can be accomplish. This system could be implemented into any hardware and software since it is not tied up to any of the specific one. However, the logical design will illustrate the functions of the system in all aspects. In the physical design, the logical design will be interpret into the physical or technical specifications by convert the systems data to the structured systems design. DIALOGUE INDIVIDUAL CUSTOMER INFORMATION Figure 1 0 | Log-OnScreenSystem | 1 |...
Words: 3417 - Pages: 14
...Avinash Shankar Coleman University Database Integration – A framework The Physical Database Design depicts the actual structure of a set of relational tables specific to the platform and Database Management Systems (DBMS) on which the database is implemented. It is used to transition a logical data design into a physical database design that can be used to generate Data Definition Language (DDL). It also takes the current Systems environment into consideration, as well as some non-functional requirements. Basically the Physical Database Design is the implementation of the logical data design with any changes needed for physical considerations, such as capacity and performance. A physical database design is performed in three stages (LePendu, P., & Dou, D., 2011, p. 217 to 244): 1. Logical database design, which includes gathering of business requirements, developing a logical data model, and designing how to load the data 2. Conversion of the logical data design into a Physical Database Design includes table definitions, primary and foreign key relationships, and basic indexing 3. Post deployment Physical Database Design (often performed by a database administrator) includes improving performance, reducing I/O, and streamlining administration tasks. Data Integration Layer The data integration layer should be modeled in 3rd normal form or near 3rd normal form and is considered to be similar to an operational data design. In addition, the data integration layer...
Words: 582 - Pages: 3
...Semester One Mid-semester Examinations, 2015 MGTS1201 Computer-based Information Systems Venue Seat Number ________ Student Number |__|__|__|__|__|__|__|__| Family Name This exam paper must not be removed from the venue ____________________ _____________________ First Name _____________________ School of Business EXAMINATION Semester One Mid-semester Examinations, 2015 MGTS1201 Computer-based Information Systems This paper is for St Lucia Campus students. Examination Duration: 60 minutes Reading Time: 10 minutes Exam Conditions: For Examiner Use Only Question Mark This is a School Examination This is a Closed Book Examination - specified materials permitted During reading time - write only on the rough paper provided This examination paper will NOT be released to the Library Materials Permitted In The Exam Venue: (No electronic aids are permitted e.g. laptops, phones) An unmarked Bilingual dictionary is permitted Calculators - No calculators permitted Materials To Be Supplied To Students: 1 x Multiple Choice Answer Sheet Rough Paper Instructions To Students: Please answer all multiple choice questions (MCQ) in the MCQ answer sheet provided. Please answer all short answer questions in the space provided within the examination paper. Please ensure you write your student number and name on the MCQ answer sheet...
Words: 2471 - Pages: 10