Database Design, SQL, Relational Algebra, Ethics, Security, and Issues

This assignment presents a comprehensive solution to a database design problem. Part 1 focuses on the database design process, including Entity-Relationship (ER) diagrams and the normalization process, covering 1NF, 2NF, and 3NF. It includes detailed table structures with attributes for departments, modules, faculty, students, courses, and qualifications. Part 2 provides SQL scripts to create tables, define constraints, and populate the database with sample data. Part 3 delves into ethical, legal, and security issues within information systems, discussing policies, legislation, and the role of information security professionals in managing risks and mitigating liability. The assignment also covers computer crime laws, including the Computer Fraud and Abuse Act, and relational algebra queries to extract specific data from the designed database.