Database Design and Implementation

Question: Describe about the CQU shopping complex.Draw an appropriate ER diagram. Answer: 1. Entity Relationship Diagram Figure 1: ER Diagram of CQSC Complex 2. A Assumptions Business owner: The researcher identifies the information about the business owners from the background study of CQU shopping complex. Here the business owners can lease one or more shops if they fulfill the agreement criteria. Here CQSC holds three different type of information of a business owner, such as about one or more person who rent a shop, shop-premises and liability insurance. Shop-premise: According to the background study of CQSC, the researcher finds the shop premises. The shopping complex has many floors, therefore; they need to record that a shop located at which section and floor. After including the floor and section information, they need to track size of the shop, decoration cost, electricity consumption and duration of a lease agreement. Discount offered: It is obvious that every shop provides a discount or offer to attracted customers. Now the CQSC provides an advertisement as a whole complex for attracting more business owner along with customers. Here a shop provides an offer or discount on some product or service for a limited period with customer term and conditions. 2. B Showing shop premises in ER data modelling The researcher identifies that all shop premises are almost same but according to their product, they need to add more entities that are external. Now the Shop of CQSC has a unique number for record shop-premise. In the above ER-Diagram, the database designer adds a relationship between these two entities, which done by the Premise-code. Here the below figure, shows how this relation is developed. 3. All the relations Owner (Serial code, Name, Address, Contact) Shopping_Catalogues (ID_Number, ReleaseDate, ShopID, Type) Discount (Discount_ID, product_or_service_details, TC, Start_date, End_Date) advertisements (advertise_number, Product_or_service, End_date, Start_date, Discount_ID) LIABILITY_INSURANCE (LI_Code, Type, TC, Sum_assure, ShopCode) CQSC_SHOP (Serial_Number, Name, Type, Floor_level, Premise_Id, LI_Code) Shop_premise (Premise_Id, Size_in_SquarerMeter, Decoration_Cost, Section, Duration, Electricity_Consumption) 4. Column specifications Table Name Attribute name Data type key Default value Validation rule CQSC_SHOP Serial_Number Short Text Primary key CQSC Name Short Text Type Short Text Floor_level Number Between 0 and 10 Premise_Id Short Text Foreign Key PI LI_Code Short Text Foreign Key LI Bibliography Abadi, D., Boncz, P., Harizopoulos, S., Idreos, S. and Madden, S., 2013. The design and implementation of modern column-oriented database systems. Now. Aref, M., ten Cate, B., Green, T.J., Kimelfeld, B., Olteanu, D., Pasalic, E., Veldhuizen, T.L. and Washburn, G., 2015, May. Design and implementation of the LogicBlox system. In Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data (pp. 1371-1382). ACM. Corbett, J.C., Dean, J., Epstein, M., Fikes, A., Frost, C., Furman, J.J., Ghemawat, S., Gubarev, A., Heiser, C., Hochschild, P. and Hsieh, W., 2013. Spanner: Googles globally distributed database. ACM Transactions on Computer Systems (TOCS), 31(3), p.8. Coronel, C. and Morris, S., 2016. Database Systems: Design, Implementation, Management. Cengage Learning. Hernandez, M.J., 2013. Database design for mere mortals: a hands-on guide to relational database design. Pearson Education. Merriam, S.B. and Tisdell, E.J., 2015. Qualitative research: A guide to design and implementation. John Wiley Sons. Nwosu, K.C., Thuraisingham, B. and Berra, P.B. eds., 2012. Multimedia Database Systems: design and implementation strategies. Springer Science Business Media. Pfaff, B., Pettit, J., Koponen, T., Jackson, E., Zhou, A., Rajahalme, J., Gross, J., Wang, A., Stringer, J., Shelar, P. and Amidon, K., 2015. The design and implementation of open vswitch. In 12th USENIX Symposium on Networked Systems Design and Implementation (NSDI 15) (pp. 117-130). Shmueli, E., Vaisenberg, R., Gudes, E. and Elovici, Y., 2014. Implementing a database encryption solution, design and implementation issues. Computers security, 44, pp.33-50. Smalheiser, N.R., Lin, C., Jia, L., Jiang, Y., Cohen, A.M., Yu, C., Davis, J.M., Adams, C.E., McDonagh, M.S. and Meng, W., 2014. Design and implementation of Metta, a metasearch engine for biomedical literature retrieval intended for systematic reviewers. Health Information Science and Systems, 2(1), pp.1-9. Zhai, H., Shi, H. and Zhai, R., 2013, October. The Design and Implementation of Database on Library Management Information System. In Applied Mechanics and Materials (Vol. 347, pp. 2533-2535). Zhang, T., Chowdhery, A., Bahl, P.V., Jamieson, K. and Banerjee, S., 2015, September. The design and implementation of a wireless video surveillance system. In Proceedings of the 21st Annual International Conference on Mobile Computing and Networking.