Database Implementation

Question: Write report on database implementation. Answer: Data Addition in Multi-Valued Attributes The multi-valued attribute contains so many values and it is very tricky to handle that. The multi-valued attribute contains different values like a customer may offer price for different properties and to handle this, there are different solutions. For example, to add extra fields in tables Customer or Property. But the best solution is to make composite entity that contains different required fields from both tables and store only relevant data. It saves the database storage space and work efficiently. Property Address as Composite Attribute The property address contains more than one parameter like address, city, state etc. Therefore, to make the property address as composite address is a very good decision. It is the best point if the property address is composite address because by this the can be forced to enter all the necessary details like state, city etc. and it is very necessary for the business point of view. References [1] P. Litwin (n.d.), Fundamentals of Relational Database Design. [2] H. Bdr (2013), SQL Database.