Database Design Concept - 1054 Words

Apply the database development cycle to a given data set Database development creates enterprise data modeling, which forms the range and wide-ranging contents of organizational databases. There are 5 phases in Database Development Cycle: Planning; Analysis; Design; Implementation and Maintenance. Planning In Planning Stage, the organization needs to know why do they need the database; what do they want the database to do; and how are they going to make the database. This is also where the organization will create a relevant department to handle the project and hiring a project manager. Project manager will determine the duration and the cost of the project. Analysis After the organization creates the relevant department, the†¦show more content†¦For example for my employees, I have used from’E01’ and for my owners, I have used from ‘ON01’. I also have used different ID for each table because to avoid confusion. For example, one owner can have multiple properties or one property can have multiple owners. From the relationship I have built, the data will be shown like in figure 8. The purpose of Relationship is to manage two tables together that shares related attributes. This to know whether the relation is one-to-many, one-to-one or many-to-many relationship. But from above image, it shows that all tables have one-to-many relationship. To know how does ‘many’ look like in relationship table, it will show infinity () symbol. The purpose of Queries is to let the user to find for a specific data or end results such as Total sales price of properties for each location which is shown in Fig. 10 The purpose for form is to enter, edit, and interact with multiple data. In forms you also can create buttons such as, Add, Save, Delete, Previous Records and Next Records. It is also less time consuming for the user to enter a data. The user doesn’t have to enter data through table because the form itself has shown Add and Save button. But the form must have relevant field for the user to enter the data. The purpose for Reports is to show the review records in systematized manner. Complex problems with more than one variable have beenShow MoreRelatedBasic Database Design Concepts2587 Words   |  11 PagesThe Fundamentals of Database Design To end up with a good ‘relational database’ application, you need to ask: Do I actually need one? If so, how far do you want to take it? By this I mean, is this to be a simple database to store information about only one, or very few, related entities (i.e. a list of people who attended a certain event, and how they came to hear about the event) which are not likely to change; or a permanent and well used application with several different entities (i.e.Read MoreUnit 17 - Database Design Concepts1192 Words   |  5 PagesUnit 17 – Database Design Concepts a) Write and describe a variety uses organisations make of use of databases and the issues they face - P1.1 Integrity of data Data integrity refers to preserving and promising the accuracy and consistency of data over its entire life-cycle. It is also the critical aspect to the design, implementation and usage of any system. This system can store, process or retrieve data. Data integrity can be negotiated in a number of ways that include: †¢ Human errors when dataRead Morequestion answer1663 Words   |  7 Pagesdisjoint constraints of specialization/generalization are distinct giving the following four categories: mandatory and nondisjoint, optional and nondisjoint, mandatory and disjoint, and optional and disjoint. 13.8- Describe and contrast the concept of aggregation and composition and provide an example of each. Aggregation: represents a â€Å"has a† or â€Å"is part of† relationship between entity types, where one represents the â€Å"whole† and the other the â€Å"part†. The relationship represents an associationRead MoreDatabase Design and Implementation38677 Words   |  155 PagesPhyloInformatics 7: 1-66 - 2005 Relational Database Design and Implementation for Biodiversity Informatics Paul J. Morris The Academy of Natural Sciences 1900 Ben Franklin Parkway, Philadelphia, PA 19103 USA Received: 28 October 2004 - Accepted: 19 January 2005 Abstract The complexity of natural history collection information and similar information within the scope of biodiversity informatics poses significant challenges for effective long term stewardship of that information in electronicRead MoreOnline Registration3963 Words   |  16 PagesDESIGN AND IMPLEMENATION OF A WEB BASED ONLINE STUDENT REGISTRATION SYSTEM WITH SMS FEEDBACK. CASE STUDY: KAMPALA INTERNATIONAL UNIVERSITY . BY OTAJEREHA KENNETH ONORIODE BIT/42017/91/DF A PROJECT PROPOSAL SUBMITTED TO THE SCHOOL OF COMPUTER STUDIES IN PARTIAL FULLFILMENT OF THE REQUIREMENT FOR THE AWARD OF DEGREE OF BACHELOR OF INFORMATION TECHNOLOGY OF KAMPALA INTERNATIONAL UNIVERSITY DECLARATION I OTAJEREHE KENNETH ONORIODE, BIT/42017/91/DF declares that thisRead MoreData Modeling Concepts1133 Words   |  5 PagesData Modeling Concepts COM 660 Data Modeling Concepts Following document explains what are data models and the importance of data model. Building a good data model helps organizations in software development, data base design and product maintenance. The document explains the theory, even if it looks like the organizations are spending substantial amount of resources on developing data models, but still it helps organization, keeping the costs low and build a better product. Database constitutesRead MoreDesign Of The Electronic Health Records System1118 Words   |  5 PagesThe purpose of this section is to assist in formalizing ideas for the design of The Electronic Health Records system. Speciï ¬ cally, this section will illustrate the unique attributes of individual Electronic Health Records databases, explain how these databases are constructed, describe their uses and data elements and types. It will also produce a detailed data model of the database to meet the end user requirement. The Enterprise Data Model System methodology has the following main stages: At thisRead MoreDevry Bis 245 All Discussions Question - Graded1414 Words   |  6 PagesAt JOHNMATE1122@GMAIL.COM DeVrY BIS 245 All Discussions Question - Graded WEEK 1 Databases and Gathering Requirements (graded) 1. Why are databases important to business? How do databases generate sales and-or profits? What databases do you interact with, and how do they benefit you? 2. What is meant by requirements gathering, and why is it important to clearly define the data requirements of a database before creating it? 3. Read the General Business Example on page 7 of the Frost sectionRead MoreLessons Learned As A Transfer Student Essay1152 Words   |  5 PagesCampbell University were (ITS-345) Database Management , (ITS-410) System Analysis Design Dev, and (ITS-410) Networking Telecommunication. In taking these courses, I felt these courses taught me relevant concepts and examples that I used and applied in my project. These courses also helped me learn about concepts such as time management in project and how management is an important aspect in any project development. These courses were also helpful in that the concepts provided great insights in possibleRead Moreâ€Å"Logical Design, Part 1† Essay1428 Words   |  6 Pagestwo to three page paper titled â€Å"Logical Design, Part 1† whereas I am a recently hired consultant for ACME Global Consulting to procure requirements for a large database. In this scenario, â€Å"Logical Design, Part 1†, I will develop a datab ase management systems to convince a set of clients of the benefits of using the Entity–Relationship model (E-R) in developing a database. In addition, my management would like the following points addressed in my design: (1). List the advantages of a relational