Construction Company Database - A construction company has many branches spread all over the country. The company
Question:
Construction Company Database - A construction company has many branches spread all over the country. The company has two types of construction to offer: Housing and Commercial. The housing company provides low-income housing, medium-style housing, and high-end housing schemes, while commercial side, it offers multiplexes and shopping zones. The customers of the company may be individuals or corporate clients. Company stores the information about employees' work for it. questions: A discussion on normalization, the normal form that each entity is in, how normalization was achieved, and why that is optimal. required: 1. All entities and relationship in appropriate normal form 2. Discussion of normalisation for all entities and relationships 3. Appropriate interpretation of each normal form, arguments for leaving schema in the normal form you consider optimal.
Operations Management Processes And Supply Chains
ISBN: 9781292409863
13th Global Edition
Authors: Lee Krajewski, Naresh Malhotra, Larry Ritzman