Database Management Systems

Question: For this assignment you will implement and query a database from a supplied ER Diagram and Schema. You will be required to write the SQL statements to create the database structures, to fill the database with data and to run queries on the data. Answer: Relational Schema Figure 1: Relational Schema Bibliography Beach, B. and Platt, D.C., Tivo Inc., 2015. Distributed database management system. U.S. Patent 9,195,694. Cable, J.D. and Whitaker, L.L., TOTAL SYSTEM SERVICES, INC., 2016. Database Management System Tools for An Automated Work to Stage Process. U.S. Patent 20,160,070,698. Charlet, K.J., Church, N.D., Hite, K.D. and Tran, R.V., Charlet and Kyle J., 2015. MANAGING DATA CONVERSION FOR USER-DEFINED DATA TYPES WITHIN A DATABASE MANAGEMENT SYSTEM. U.S. Patent 20,150,254,316. Clifford, P. and Robinson, M., FACE RECORDING and MEASUREMENTS LTD., 2016. DATABASE MANAGEMENT SYSTEM. U.S. Patent 20,160,070,751. Clifford, P., Robinson, M. and Rogers, T., FACE RECORDING and MEASUREMENTS LTD, 2016. DATABASE MANAGEMENT SYSTEM. U.S. Patent 20,160,078,104. DeBrabant, J., Pavlo, A., Tu, S., Stonebraker, M. and Zdonik, S., 2013. Anti-caching: A new approach to database management system architecture. Proceedings of the VLDB Endowment, 6(14), pp.1942-1953. Grefen, P., Pernici, B. and Snchez, G. eds., 2012. Database support for workflow management: the WIDE project (Vol. 491). Springer Science Business Media. Krishnamurthy, S., Thombre, N., Conway, N., Li, W.H. and Hoyer, M., Cisco Technology, Inc, 2014. Addition and processing of continuous SQL queries in a streaming relational database management system. U.S. Patent 8,745,070. Lee, H., Chapiro, J., Schernthaner, R., Duran, R., Wang, Z., Gorodetski, B., Geschwind, J.F. and Lin, M., 2015. How I do it: a practical database management system to assist clinical research teams with data collection, organization, and reporting. Academic radiology, 22(4), pp.527-533. Ordonez, C., Teradata Us, Inc., 2014. Horizontal aggregations in a relational database management system. U.S. Patent 8,712,993. Pakhira, M.K., 2012. Database Management System. PHI Learning Pvt. Ltd.. Starkey, J.A., Nuodb Inc., 2013. Database management system. U.S. Patent 8,504,523. Thomas, A.D., Stamatis, D., Bertsch, J., Isbandi, M., Jansson, J., Mallajosyula, J., Pagani, I., Lobos, E.A., Kyrpides, N.C. and Reddy, T., 2014. The Genomes OnLine Database (GOLD) v. 5: a metadata management system based on a four level (meta) genome project classifications (No. LBNL-7089E). Ernest Orlando Lawrence Berkeley National Laboratory, Berkeley, CA (US). Varshney, G., 2012. Database Management System. Global Vision Publishing House. Wu, Y., Rubin, D.L., Woods, R.W., Elezaby, M. and Burnside, E.S., 2014. Developing a comprehensive database management system for organization and evaluation of mammography datasets. Cancer informatics, 13(Suppl 3), p.53.