Database Design Concept

1054 WordsJun 13, 20125 Pages
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 been

More about Database Design Concept

Open Document