Database Management Assignment Example | Topics and Well Written Essays - 1500 words

Database Management - Assignment Example The wild wood company offers fair rates to employees who live and maintain the apartments. It is the tradition of the wild wood apartments to ensure that they meet to discuss on how to improve the standards of their apartments and plan to expand their business in real estate. Tenants fill questionnaires every end month to air out complaints or suggest on new ways to maintain the apartments. The introduction of a database will be to meet the daily needs of the employees and the tenants who live within the Wild Wood apartments. It will also help in keeping of records of the apartments such as expenditure and the rents paid by the tenants. The database may also have records on the margin of profits and losses of the apartments. 4. Building the physical database: The data model will be translated to the Relational Database Management system. Tables, Columns with specific data types and Relational and other constraints created. Time allotted 2 days. 5. Testing and security: Sample data will be entered and each of the business rules and requirements will be tested. General database security and security related to business rules will also be tested. Time allotted 3 weeks. 6. Database completion and installation: Final changes and corrections are made. Sample data will be removed and the database installed on a server. Final testing for server access and connections. Time allotted 2