Project Option 2: University Database System Student Name: STUDENT NAME Instructor: Dr. JUNPING SUN DATE OF SUBMISSION: APRIL 14 2018 NOVA SOUTH EASTERN UNIVERSITY Master of Computer Science CISC 660 Database Management Systems Winter 2018 Table of Contents No. Part Page No. Acknowledgement 4 Introduction – Project Ouline 4 1. Part1: Requirements Specification 1.1 Problem Definition 6 1.2 Partitioning the Requirements 6 2. Part2: Conceptual Schema Design 2.1 Identifying Entities and Attributes 13 2.2 Identifying Relationships Attributes and Constraints 15 2.3 Extended Entity-Relationship Diagram 18 2.4 Conceptual Schema Design Language Definitions 19 3. Part3: Relational Schema Design 3.1 Transforming Entities and Relationships to Relational Schemas 29 3.2 Referential Integrity Constraints and Functional Dependencies 31 4. Part 4: Join Paths 4.1 List of Join Paths 35 5. Part 5: Normalization 5.1 Initial List of Un-normalized Tables 36 5.2 Normalization – First Normal Form 37 5.3 Normalization – Second Normal Form by the user. Although a number of integrity constraints have been used to validate data more stringent constraints could be incorporated through the use of pattern-matching and assertions defined on the database tables. Extended entity-relationship diagram features such as multiple inheritance could also be incorporated to reflect more of a real-world scenario. For example in a number of universities a graduate student also plays the role of a teaching assistant. In this case the graduate student entity would inherit attributes from both the student entity as well as the faculty entity. References Batini C. Ceri S. & Navathe S. B. (1972). Conceptual Database Design: An Entity-Relationship Approach. San Francisco CA: Benjamin / Cummings Publishing. Elmasri R. & Navathe S. B. (2010). Fundamentals of Database Systems (6th ed.). New Jersey NJ: Pearson Education. Silberschatz A. Korth H. F. & Sudharshan S.(2010). Database System Concepts (6th ed.). New York NY:McGraw Hill. [...]
Instructions will be provided in a pdf file. I will need a research paper at a master degree level in which topic will be based about No SQL databases.