I need help with my Data Curation project.
Please provide clear, accurate, and well-organized step-by-step guidance based on the project requirements.
I want the explanation to be easy to understand, academically appropriate, and thorough enough to help me produce a high-quality submission.
Please focus on correctness, clarity, and proper organization of the work.
Category: Databases
-
Need help with Data Curation project
-
Need help with Data Curation project
I need help with my Data Curation project.
Please provide clear, accurate, and well-organized step-by-step guidance based on the project requirements.
I want the explanation to be easy to understand, academically appropriate, and thorough enough to help me produce a high-quality submission.
Please focus on correctness, clarity, and proper organization of the work. -
GHADA_IT403
Project Instructions
- You can work on this project as a group (minimum 3 and maximum 4 students). Each group member must submit the project individually with all group member names mentioned on the cover page.
- This project worth 14 marks and will be distributed as in the following:
o Identify the entity types, attributes, keys. (1.5 marks)
o Identify the relationships and cardinalities. (1.5 marks)
o Design ER model. (3 marks)
o Schemas after Normalization (2 marks)
o Create the normalized tables. (1.5 marks)
o Populate your tables with at least 5 rows. (1.5 marks)
o Execute the requested sample queries. (3 marks)
- Each student must submit one report about their chosen Project via the Blackboard (Email submission will not be accepted and will be awarded ZERO marks) containing the following:
a) ER Diagram.
b) All schemas before normalization.
c) All schemas after normalization.
d) All SQL statements of:
Creating tables.
Inserting data in tables.
e) All requested queries/results.
- Screenshots from MySQL (or any other software you use) of all the tables after population and query results.
- You are advised to make your work clear and well presented; marks may be reduced for poor presentation. This includes filling in your information on the cover page.
- You MUST show all your work, and text must not be converted into an image unless specified otherwise by the question.
- Late submission will result in ZERO marks being awarded.
- The work should be your own. Copying from students or other resources, including AI software, will result in ZERO marks.
Project Description
Global Research Collaboration Platform.
Consider a global digital platform is being developed to manage research partnerships between universities, research centers, funding agencies, and industry partners across different countries.
The system aims to centralize all critical information and make collaboration more transparent, efficient, and organized.
Universities and Research Centers Management
Each participating university in the system is identified by a University_ID. The platform stores information such as the universitys name, country, international ranking, accreditation status, and year of establishment. Each university contains multiple colleges, with each college uniquely identified by a College_ID, and the system stores its name, head of college, and location.
Colleges are divided into academic departments. Every department has a unique Department_ID, department name, specialization field, office location, and contact email. Within these departments, multiple research centers operate as specialized units focusing on particular fields of study. Each research center is assigned a Center_ID, center name, research focus area, annual budget, establishment date, and a director who is a registered researcher in the system.
Researcher Info Management
The platform maintains detailed profiles for all researchers. Each researcher has a unique Researcher_ID, full name, nationality, date of birth, gender, institutional email, ORCID number, academic rank, and areas of specialization.
Researchers are affiliated with a single department, connecting them to a specific college and university. However, they may work on multiple projects, possibly in collaboration with researchers from other departments or research centers.
The system also records researchers employment details, including start date, contract type, and experience. It calculates derived values such as total publications and total citations based on stored publication data, providing an overview of each researchers academic contributions.
Research Project Management
Research projects are central to the platform. Each project has a unique Project_ID, with attributes including project title, abstract, research domain, start and end dates, total budget, and status (e.g., Proposed, Active, Completed).
Each project is associated with a primary research center, linking it directly to a department, college, and university. Researchers from that research center, as well as other affiliated centers, may be assigned to the project. The system tracks each researchers role and contribution within the project.
Global Research Collaboration Platform.
a) Fill in the table below with all the Entities based on the given requirements:
Entity Type Attributes of the Entity Key
b) Fill in the table below with all the relationship type based on the given requirements.
Relationship Type Entities connected by the relationship type Cardinality Relationship attribute
c) Draw the ER Diagram
d) Provide the database schemas after the normalization
e) Create the normalized tables and populate them with at least 5 rows each (Provide screenshots of all the tables after filling in the data).
f) Write SQL queries to find the following (Provide screenshots of query results):
1. List all researchers specializing in Computer Science and display their details.
2. List all research centers established after 2020 and display their details.
3. List the Project_ID, project title, project domain, the full names of all researchers involved, for projects with status Active.
4. List all departments with the number of researchers in each, ordered by highest to lowest.
5. List Project_ID, Title, and the Name of the research center hosting each project.
6. Retrieve the full name of researchers involved in more than one project along with the number of projects they are part of.
-
Computer Ethics (0102453) Project and Presentation
AL AIN UNIVERSITY
College of Engineering (CoE)
Computer Ethics (0102453)
Project and Presentation
Student Name
Student ID
Due Date
19th April 2025 @ 23:59 pm on Moodle
Problem #
Course Learning
Outcomes (CLO)Total
MarkStudent
Mark1
1,2,3
10
10
Project Assignment: Ethical Dilemmas in Modern Computing
This assignment will consist of a written report and an accompanying presentation. The students will address the following Course Learning Outcomes (CLOs):
- Describe general concepts related to computer ethics.
- Evaluate contemporary ethical problems using major ethical theories.
- Evaluate issues related to cyberspace intellectual property.
Part 1: Written Report
Topic:
Choose a contemporary issue related to computer ethics, specifically one involving Artificial Intelligence, cyberspace and intellectual property rights. The selected topic should be specific in scope. For example, facial recognition would not be an appropriate focus because it has a broad scope. Instead, you could select one aspect of facial recognition technology such as automated gender recognition [ Alternatively, you might investigate the use of facial recognition in a specific social context such as in public housing.
Below is list of a number of areas from which to choose that subject:
Artificial Intelligence:
oEthical Issues in AIGenerated Content: Studying how tools that create text or images may affect honesty, creativity, and academic integrity.
oEthical Use of Predictive Policing Tools: Analyze harms, fairness, and accountability when police use AI to predict crime.
oAutonomous Vehicles and Moral Decisions: Exploring how selfdriving cars should make choices in dangerous situations
Software Development
oDark Patterns in User Interface Design: Studying how some apps use design tricks to influence user behavior in unethical ways.
oResponsible Disclosure of Security Flaws: Describing ethical duties of developers, compare disclosure policies, and evaluate a disclosure case using major ethical theories
Data Privacy
oData Breaches and Responsibility: Exploring who is ethically responsible when personal data is leaked.
oLocation Tracking and Consent: Describe privacy concepts, evaluate a companys location policy using rightsbased and consequentialist views, and assess data ownership questions.
Communication Technologies
oMisinformation in Digital Communication: Exploring how false information spreads and what ethical duties platforms have to stop it.
Intellectual property
oRight to Repair: The Ethical Conflict between Intellectual Property and Hardware Longevity.
Copyright violations in cyberspace
oFair Use vs. Copyright: Explore the tension between fair use doctrines and copyright protections, especially in the digital age where content can be easily shared and reused. When does the sharing of copyrighted material cross ethical boundaries?
Open-source vs. proprietary software models
oSecurity and Trust in Open-Source Software: Explore the ethics of security in open-source vs. proprietary software. Open-source advocates argue that transparency leads to better security, while proprietary models rely on secrecy. Which approach better protects users?
Large language models (LLMs) as Islamic muftis
oAccuracy and Reliability in Religious Rulings: LLMs are trained on large datasets, but their responses are based on statistical patterns rather than deep understanding or lived religious experience. When asked for fatwas or religious guidance, an LLM might provide inaccurate or oversimplified answers, which could mislead people seeking authentic Islamic advice. A key question is: Can a machine learning model reliably provide religious rulings, and what are the risks of misinformation?
Building an Islamic Ethical Framework for LLM-Based Religious Guidance
oInvestigates whether an Islamic ethical framework can be developed to evaluate bias, hallucination, trust, and intellectual-property concerns in large language models used to generate Islamic religious guidance online.
Report Outline:
- Introduction to Computer Ethics (CLO 1):
Define and explain what computer ethics is and why it is important.
Introduce the chosen issue and its relevance in today’s technological landscape.
- Ethical Analysis Using Theories (CLO 2):
Apply major ethical theories (such as Utilitarianism, Kantianism, Social Contract Theory) to evaluate the ethical dilemma.
Analyze the perspectives of different stakeholders involved, such as the public, developers, companies, and governments.
- Cyberspace Intellectual Property (CLO 3):
Evaluate how intellectual property laws apply in cyberspace regarding the issue.
Discuss the challenges and potential solutions for managing intellectual property in a digital environment.
Address ethical concerns about the balance between open-source models and intellectual property protections.
- Conclusion:
Summarize your findings, stating which ethical theory best applies to the issue.
Reflect on the potential future implications for computer ethics as technology evolves.
- References
Part 2: Presentation (10-15 minutes)
Presentation Structure:
The presentation should follow the structure of the report but be concise and visual, summarizing key points.
- Introduction to Computer Ethics (CLO 1):
Provide a brief definition and explanation of computer ethics.
Present an overview of the ethical issue chosen.
- Evaluation Using Ethical Theories (CLO 2):
Use examples from the report to show how different ethical theories (Utilitarianism, Kantianism, etc.) apply to the issue.
- Cyberspace and Intellectual Property (CLO 3):
Visually show how intellectual property rights are violated or upheld in cyberspace.
Discuss the ethical implications of protecting intellectual property online.
- Conclusion:
End with a summary of your findings and reflections on how the ethical issue could be addressed in the future.
Visual Aids:
Use slides to show data, case studies, and examples of intellectual property issues.
Include diagrams or flowcharts to explain complex ethical theories.
Add videos or images to make your points more engaging.
Submission Guidelines:
- Written Report: Submit the written report in PDF or Word format (5-7 pages).
- Presentation: Create the presentation using PowerPoint or Google Slides (10-15 slides).
- Team Works: You can work in a group of up to 5 students.
-
GHADA_IT403
Project Instructions
- You can work on this project as a group (minimum 3 and maximum 4 students). Each group member must submit the project individually with all group member names mentioned on the cover page.
- This project worth 14 marks and will be distributed as in the following:
o Identify the entity types, attributes, keys. (1.5 marks)
o Identify the relationships and cardinalities. (1.5 marks)
o Design ER model. (3 marks)
o Schemas after Normalization (2 marks)
o Create the normalized tables. (1.5 marks)
o Populate your tables with at least 5 rows. (1.5 marks)
o Execute the requested sample queries. (3 marks)
- Each student must submit one report about their chosen Project via the Blackboard (Email submission will not be accepted and will be awarded ZERO marks) containing the following:
a) ER Diagram.
b) All schemas before normalization.
c) All schemas after normalization.
d) All SQL statements of:
Creating tables.
Inserting data in tables.
e) All requested queries/results.
- Screenshots from MySQL (or any other software you use) of all the tables after population and query results.
- You are advised to make your work clear and well presented; marks may be reduced for poor presentation. This includes filling in your information on the cover page.
- You MUST show all your work, and text must not be converted into an image unless specified otherwise by the question.
- Late submission will result in ZERO marks being awarded.
- The work should be your own. Copying from students or other resources, including AI software, will result in ZERO marks.
Project Description
Global Research Collaboration Platform.
Consider a global digital platform is being developed to manage research partnerships between universities, research centers, funding agencies, and industry partners across different countries.
The system aims to centralize all critical information and make collaboration more transparent, efficient, and organized.
Universities and Research Centers Management
Each participating university in the system is identified by a University_ID. The platform stores information such as the universitys name, country, international ranking, accreditation status, and year of establishment. Each university contains multiple colleges, with each college uniquely identified by a College_ID, and the system stores its name, head of college, and location.
Colleges are divided into academic departments. Every department has a unique Department_ID, department name, specialization field, office location, and contact email. Within these departments, multiple research centers operate as specialized units focusing on particular fields of study. Each research center is assigned a Center_ID, center name, research focus area, annual budget, establishment date, and a director who is a registered researcher in the system.
Researcher Info Management
The platform maintains detailed profiles for all researchers. Each researcher has a unique Researcher_ID, full name, nationality, date of birth, gender, institutional email, ORCID number, academic rank, and areas of specialization.
Researchers are affiliated with a single department, connecting them to a specific college and university. However, they may work on multiple projects, possibly in collaboration with researchers from other departments or research centers.
The system also records researchers employment details, including start date, contract type, and experience. It calculates derived values such as total publications and total citations based on stored publication data, providing an overview of each researchers academic contributions.
Research Project Management
Research projects are central to the platform. Each project has a unique Project_ID, with attributes including project title, abstract, research domain, start and end dates, total budget, and status (e.g., Proposed, Active, Completed).
Each project is associated with a primary research center, linking it directly to a department, college, and university. Researchers from that research center, as well as other affiliated centers, may be assigned to the project. The system tracks each researchers role and contribution within the project.
Global Research Collaboration Platform.
a) Fill in the table below with all the Entities based on the given requirements:
Entity Type Attributes of the Entity Key
b) Fill in the table below with all the relationship type based on the given requirements.
Relationship Type Entities connected by the relationship type Cardinality Relationship attribute
c) Draw the ER Diagram
d) Provide the database schemas after the normalization
e) Create the normalized tables and populate them with at least 5 rows each (Provide screenshots of all the tables after filling in the data).
f) Write SQL queries to find the following (Provide screenshots of query results):
1. List all researchers specializing in Computer Science and display their details.
2. List all research centers established after 2020 and display their details.
3. List the Project_ID, project title, project domain, the full names of all researchers involved, for projects with status Active.
4. List all departments with the number of researchers in each, ordered by highest to lowest.
5. List Project_ID, Title, and the Name of the research center hosting each project.
6. Retrieve the full name of researchers involved in more than one project along with the number of projects they are part of.
-
Discussion
Prior to beginning work on this discussion forum, (300-400 words)
- Read Chapter 6 from your textbook Database Systems: Design, Implementation, & Management (14th ed.).
- Review the following resources
Normalization is an important step toward translating models and diagrams into relational databases.
In this Normalization exercise, you will need to normalize the Grade Report table according to the following instructions:
- Consider the following entity and its attributes.
- Entity: Grade_Report (StudentID, StudentName, Phone, DOB, Address, Email_Address, CourseNumber, CourseName, Grade, DepartmentID, DepartmentName)
- Explain the steps needed to normalize this entity to 1NF, 2NF, and 3NF.
- Normalize the entity Grade_Report to 3NF.
- List the resultant Normalized entities in the same format as the original Grade_Report.
Once the entity is normalized to 3NF:
- Describe any issues this entity might have that can be solved by normalization.
- Explain the functional dependencies that exist between the attributes.
- Explain the steps required to break up the Grade Report entity into multiple entities that each have a single theme.
-
Intoductory Data Processing with Data Bricks
Python (PySpark) and Spark SQL in Databricks
The attached document contains the assignment description and questions. Please submit your answers by uploading the following:
1. The Databricks notebook file(i.e. ipynb) that has all the code and output results of the code.
2. One PDF document with screenshots showing the Databricks UI and results as specified in each question; make sure the results match with the notebook code execution output.
-
Configure SAP Content Server repositories for DEV, QAS, PRD…
How to configure SAP Content Server for DEV, QAS, and PRD?
How to set up DMS repositories for DEV, QAS, PRD systems?
How to configure Content Server across all SAP systems?