|
Annual Report FY [Year] [Add a quote here from one of your company executives or use this space for a brief summary of the document content.] |
|
Fundamentals of Databases IT403
|
|
|
Instructions: |
|
You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format. It is your responsibility to check and make sure that you have uploaded both the correct files. Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation). Email submission will not be accepted. You are advised to make your work clear and well-presented. This includes filling your information on the cover page. You must use this template, failing which will result in zero mark. 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 mark. The work should be your own, copying from students or other resources will result in ZERO mark.
|
Project Instructions
- 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.
Glo
|
Learning Outcome(s):
|
bal .
The system aims to centralize all critical information and make collaboration more transparent, efficient, and organized.
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
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.
- Fill in the table below with all the Entities based on the given requirements:
- Fill in the table below with all the relationship type based on the given requirements.
- Draw the ER Diagram
- Provide the database schemas after the normalization
- Create the normalized tables and populate them with at least 5 rows
|
Entity Type |
Attributes of the Entity |
Key |
|
Relationship Type |
Entities connected by the relationship type |
Cardinality |
Relationship attribute |
- List all researchers specializing in Computer Science and display their details.
- List all research centers established after 2020 and display their details.
- List the Project_ID, project title, project domain, the full names of all researchers involved, for projects with status Active.
- List all departments with the number of researchers in each, ordered by highest to lowest.
- List Project_ID, Title, and the Name of the research center hosting each project.
- Retrieve the full name of researchers involved in more than one project along with the number of projects they are part of.
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
Leave a Reply
You must be logged in to post a comment.