...“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
...Database Design Paper DBM380 March 09, 2015 Database Design Paper A database is a computer structure that organizes a collection of data so that it can be accessed, updated and managed as fast and efficiently as possible. There are several classifications of databases, “For example, databases can be classified by the number of users supported, where the data are located, the type of data stored, the intended data usage, and the degree to which the data are structured. The number of users determines whether the database is classified as single-user or multiuser. A single-user database supports only one user at a time. In other words, if user A is using the database, users B and C must wait until user A is done. A single-user database that runs on a personal computer is called a desktop database. In contrast, a multiuser database supports multiple users at the same time. When the multiuser database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization, it is called a workgroup database. When the database is used by the entire organization and supports many users (more than 50, usually hundreds) across many departments, the database is known as an enterprise database” (Coronel, Morris, & Rob, 2013, p. 9). Database architecture describes the rules that dictate how data is stored in a database and how data is accessed by components of a system. Database management software, such as Oracle, is designed to handle...
Words: 404 - Pages: 2
...Database Concepts David Emersion DBM380 6/29/2015 Wade Fergus Database Concepts In an age when information is power, each business in the market place must make use of every tool at its disposal. Efficiency is the hallmark of any successful business. For a business to be efficient it must be the master of managing its own information. Time is money, and using an ineffective information management system is simply money down the drain. Quick access to accurate information is crucial to an organization’s success. Fortunately, businesses have a powerful weapon at their disposal – databases. Database Systems Every organization from small non-profit teams up to huge corporations supporting millions of customers must keep records of different types of data. These data can vary from inventory prices, to payroll, to medical records, and everything in between. The common challenges that these organizations face is keeping the data accurate, relatively easy to use, and secure. The solution to this problem is to use a database that fits the needs of the organization. A database is a system that houses data and metadata. Metadata is the information about the data and includes “information such as the name of each data element, the type of values (numeric, dates, or text) stored on each data element, and whether the data element can be left empty” (Coronel, Morris, & Rob, 2013, p. 7). A database system collectively...
Words: 578 - Pages: 3
...Database Design Tyrone Thompson DBM380 November 28, 2010 Kurt Jost A database is a table-based tool offering an organized mechanism to store, manage, and retrieve information. Relational data becomes a powerful business tool when queried for desired information by users and relationships established between other pieces of data. A variety of different types of databases are available, some more common than others. The database administrator’s task is to choose the database type that will best work with the data provided. A database system consists of four components: database, a database management system, database application, and users. At my workplace various databases are in use. At Omega Engineering for three decades its handbooks have served as valuable reference tools for engineers around the world. Though it is an established direct-marketing pioneer, the people, facilities and superior client services go well beyond the original Omega handbooks and have progressed into a highly automated, online data warehouse accessed via its website www.omega.com. Omega's world-famous product handbooks and encyclopedias, online as well as in print, feature hundreds of thousands of products, technical tips, topical articles, reference charts and graphs, and some of the largest, most detailed product images in the industry. A document-oriented database layers other database systems, for example, a relational database. Structured query language (SQL) server databases are used...
Words: 840 - Pages: 4
