Bright Academic Experts

Category: Databases

  • Database Design

    Case Study: Greenleaf Community Library

    Greenleaf Community Library is a public library in Melbourne that aims to provide residents with access tobooks, digital resources, and educational programs. To enhance member services, the library plans to developa web-based application that tracks book borrowing, reading programs, and member activity.

    You have been assigned to design the conceptual data model for the Greenleaf Library web application.The key system features are described below.
    Greenleaf Library serves hundreds of members, helping them engage in reading and lifelong learning. Tobecome a library member, individuals must complete a registration process. The system stores memberdetails such as first name, last name, address, date of birth, phone number, and email. Each member isassigned a unique membership ID upon registration.
    The library employs a number of staff including librarians and program coordinators. Each staff membersrecord includes name, gender, contact information, professional qualifications, role, and years ofexperience. Each staff member must hold a valid library certification that is uniquely assigned to them.
    The library offers a variety of reading programs and events such as Childrens Storytime, Book Club,and Digital Literacy Workshop. Each program has a unique title and a defined objective. A staff memberis responsible for coordinating each program, while one staff member may run multiple programs.
    Programs are scheduled across different time periods and may run multiple sessions. Each session has astart and end date, and members can join at any time.
    Members may enroll in multiple programs simultaneously, and the system records the date they join eachprogram. Some members may not enroll in any programs.
    Each program session may include a set of activities, such as reading challenges, discussion groups, andskill workshops. Each activity has a unique ID, name, description, and type
    The system allows members to log in their progress in activities, including a unique log ID, date ofparticipation, start time, end time, and notes on their achievements.
    Greenleaf Library also has a referral program that encourages members to invite friends or family to join.Referral relationships are tracked in the system for membership incentives.

    Task 1: Entity Relationship Diagram (ERD)

    Based on the above requirements, develop an ERD for the Greenleaf Library database.
    NOTE: Students must provide any assumptions made which are necessary to support their design.
    Steps:
    i. Identify the main entities and assign meaningful names to all entities.
    ii. Identify and name relationships between entities that you found in step (i).
    iii. Assign attributes to each entity and associate attributes with each relationship.
    iv. Identify primary keys for each entity.
    v. Specify cardinality for each relationship identified in step (ii) using crows-foot notation.
    vi. Identify foreign keys in the entities.
    vii. Ensure the diagram is consistent, readable, and uses proper notation.

    Task 2: Normalization

    The following table records member participation in various library programs during August.Each program session has defined start and end dates and may run at multiple skill levels. Members can joinmultiple sessions and may rejoin the same program at different times.

    (THE TABLE IS ATTACHED)

    Consider Table 1 and answer all the questions given below.
    i. Identify the primary key of the table.
    ii. Determine the current normal form of the table and justify your answer.
    iii. Identify all functional dependencies and classify them as full, partial, or transitive.
    iv. Normalize the table to Third Normal Form (3NF), showing all steps clearly.
    v. Identify primary and foreign keys for each resulting table.

    PLEASE make sure the answer has:
    – All entities are correctlyidentified with attributesaligned to the casedescription and allattributes required tostore many-to-manyrelationships areidentified and showncorrectly.
    – All keys are correct,clearly defined,complete, andappropriate.
    – All relationships,including the unary relationship, have beencorrectly identified andmeaningfully named. Noincorrect relationshipshave been identified,and all relationshipsalign with the givenrequirements.
    – All cardinalities havebeen accuratelyidentified and areconsistent with therequirements outlined inthe case description
    – All the foreign keys havebeen accuratelyidentified and alignedwith the establishedrelationships andcardinalities in themodel.
    – All associative entitieshave been correctlyimplemented to resolvethe many-to-manyrelationship betweenthe two entities, inaccordance with thecase description, with allprimary keys, foreignkeys and attributesproperly defined.
    – Fully correct diagram;professional layout;complete, clear, andeasy to interpret.
    – Correct primary key andnormal formal with clear and completejustification.
    – All functionaldependencies (FDs) arecorrectly identified andwritten using properconventions andnotation, including full,partial, and transitivedependencies whereapplicable.
    – Primary key identifiedfor each table in theprocess of normalisationand tables are fullynormalised to 3NF;lossless anddependency-preservingwith a clear, professionalexplanation.
    – Tables are fully correct,complete, clear, andprofessionallypresented.Al that PK/ FK have beencorrectly identified.

  • Explain Database Management System

    Explain database management system in detail with definition advantages,disadvantages,components and applications. Also explain database system structure with suitable examples.

  • Create a visually interesting poster covering an emerging tr…

    In this assignment, you will research on an emerging trend in database technology and /or anovel application of databases in modern business. You are required to create a visually engagingposter that effectively communicates your research findings. The poster should not only presentinformation but also highlight the significance and potential impact of the trend or application inthe business.

    Instructions:

    1. Research:
    Identify an emerging trend in database technology or a novel application of databases.
    Conduct thorough research using reliable sources such as peer reviewed journals,industry reports, and reputable websites.
    Understand the trend or application, its current state, and its potential future impact.

    2. Poster Creation
    The role of a poster presentation is to allow researchers the opportunity to present researchthat has been completed, but in a less formal setting than an oral presentation. In thisassignment once you have conducted your research on the selected topic, design a visuallyinteresting and informative poster.
    First, your poster should attract attention. This is best achieved by a clean design,decently sized figures and graphs with a cohesive colour scheme, and avoiding acluttered look through the use of too many different sections.
    Use a short but encompassing title at the top to inform what your story is about.
    Provide a brief overview of the selected topic. The main concepts should beunderstood within a minute of skimming. Visuals: Use images, diagrams, graphs, or charts to support and enhance yourpresentation.
    Use design tools like Canva, PowerPoint, or Adobe Spark to create your poster.
    References: Cite all sources of information in a references section.
    Ensure your poster does not exceed one page.

    3. Q&A:
    Summarize the key points of your research and its relevance to modern business.

    Please make sure the poster is in one A4 size page, include a citation section and pdf format. The poster is graded on:
    o Clarity and organization.
    o Use of visuals and their effectiveness in conveying information.
    o Overall visual appeal and creativity.
    Use in-text citations in APA style. The college uses turnitin. So, please make sure the poster and references are not AI generated. Please let me know if you have any questions.

  • Apa definisi jaringan komputer?

  • Bagaimana internet dianalogikan secara fisik dalam perkembangan teknologi?
  • Apa kepanjangan dari internet dan apa makna “interconnection” dalam konteks ini?
  • Bagaimana data dikirimkan dalam sebuah jaringan komputer?
  • Apa fungsi dari IP Address dalam jaringan komputer?

  • everything provided below



    AFTER ACCEPTING I WILL PROVIDE MORE INFO AND I MAY ASK FOR CHANGES BASED ON WHAT I SEE FIT Context Description:

    In this project, you are going to design a relational database system for a hotel reservation management system.

    The hotel manages multiple rooms of different types (e.g., single, double, suite), guests, and staff members. Guests can make reservations for specific dates, and staff are responsible for handling bookings, check-ins, check-outs, and cancellations.

    The hotel manager plans to expand the business by adding more rooms and services (such as spa and dining).

    Guests often pay a deposit at the time of reservation and the remaining balance upon check-out. The system must support multiple payment methods (Credit Card, Cash, Loyalty Points) and handle partial refunds for cancellations.

    You are required to design the database solution, implement it in your Database Management System, and develop a Python application that connects to the database you created..

    Requirments:

    You can work in a**** group of 3**** to complete the requirements below.

    1. Data Modeling:

    a. Based on the problem description, assume you are going to meet the hotel manager and ask one question. State the question, explain why it is necessary, and what data you aim to collect.

    b. Identify tables, column names, primary keys, foreign keys, and sample data for all the tables.

    c. Make sure all your tables are normalized up to the third normal form.

    d. Provide an Entity Relationship Diagram (ERD) that captures the tables, attributes, relationships, participation types, participation degrees, and deletion rules. Justify your choices.

    2. Database Creation:

    a. Based on your database design, use your database management system (XAMPP/ MYSQL server) to create your database: Write the SQL statement that builds each table in the database. Make sure you add the appropriate datatypes, sizes, constraints and deletion rules. Provide a screenshot of the output after successfully executing the CREATE TABLE statement for every table in the DBMS.

    b. Write SQL statements that populate the database with realistic data for 5 to 10 records. Ensure that the data is realistic. Take screenshots for every table populated in the DBMS.

    3. Simple Queries:

    Answer the following simple queries by writing the corresponding SQL statement and showing the resultant DBMS output, and add a simple explanation. Note that these queries do not require JOIN.

    a. Write a query that analyzes room usage and presents the results in a meaningful way that helps classify rooms based on their reservation activity. Your output should include Room-related information and a derived classification that reflects usage level.

    b. Write a query to retrieve guests whose names match specific letters of your choice, who booked a suite or deluxe room, and who made at least one reservation before.

    Note: Please Do NOT use syntax or keywords that we did not introduce in the classes.

    4. Advanced queries:

    Answer the following advanced queries by writing the corresponding SQL statement and showing the resultant DBMS output and add a simple explanation for each. Ensure all your queries are optimized and that the corresponding SQL statements are justified.

    a. Which room types generate the highest total revenue, and how do the types rank against each other in overall performance?

    b. Can you provide a list of the guest stays and the staff involved in managing those reservations for the previous year?

    c. Which reservations have overlapping times or resource conflicts that violate the reservation rules?

    d. Create a view that shares the monthly financial and reservation data.

    e. A staff member is attempting to create a room reservation, but the system must ensure that no two staff can book the same room for overlapping dates; implement a transaction to prevent such conflicts while ensuring ACID properties.

    f. How can we restructure the Reservations table to improve data retrieval speed as it grows over several years by organizing it into yearly segments?

    5. Database application:

    Build a Python-based database application that connects with the implemented database. Your application can be either menu-driven or a graphical user interface (your instructor will tell you which is preferred). The application should allow the following:

    a. Insert new records into a selected table from your database (for instance, you could allow the user to enter guest information).

    b. Update data in another table from your database (for instance, you could allow the updating of reservations).

    c. Display data from a single table, and from related tables of your choice (you could show reservations with the rooms and guests’ details).

    d. Include a search or filter feature that retrieves specific data based on user input.

    e. You should include in your report screenshots of the database connection code sections, as well as each of the requirements listed in points a-d above, and the result output when running the code.

    Submission

    1. A PDFfile that contains the following: Answers to all the questions with all required screenshots- submitted as a primarysubmission file.
    2. A Python file (.py) that contains the code for the database application.
    3. Submit a single sql file containing all code needed to recreate and populate your database (exported from XAMPP or saved as a text script from MYSQL server).
    4. Add the two files (python and sql files) into a zipped folder and submit it as a secondary sumission file.
    5. There will be **a technical interview **for the project, where you are expected to answer questions related to the project.

    Notes

    1. If you have used ChatGPT or other AI tools, please provide screenshots of the tool usage. Also, please add screenshots of all outputs in an organized manner.
    2. Answers with advanced concepts not covered in the course will get a score of 0.
    3. You are responsible for understanding every single task in your project and not partially. Please be prepared to explain your work when you are called for the technical interview to explain your answers.
    4. Make sure that you submit your own original work. Suspected plagiarism cases will be treated as possible academic misconduct and will be reported to the College Academic Integrity Committee for formal investigation.
    5. Your instructor will grade your submission based on what you submitted on the Forum within the allowed deadlines. Do not submit your assignment via email. Failure to submit an assignment or submitting an assignment for another student from the same class or another class will result in a 0 grade without the opportunity to resubmit.
    6. If you used any references to complete your tasks, please include your references in APA style.

    At the end of your assignment, include this

    Academic Integrity disclaimer:

    I hereby confirm that the work submitted for the assignment is entirely my own. I affirm that I have not used any artificial intelligence (AI) tools or any other unauthorized means to generate answers or complete any part of this assignment. The work presented reflects my own ideas, research, and understanding of the subject matter. I understand the importance of academic integrity and the consequences of submitting work that is not my own. I acknowledge that any violation of academic honesty policies may result in disciplinary action, including but not limited to a failing grade for the assignment or the entire course.

    By submitting this assignment, I declare that I have complied with the academic integrity standards set forth by CIS/ZU. I am aware of the ethical implications of using external assistance and have adhered to the principles of honesty and integrity throughout the completion of this assignment.

    Student 1 Signature: ________________________________________

    Student 2 Signature: ________________________________________


  • Fundamentals of Databases 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:

    oIdentify the entity types, attributes, keys. (1.5 marks)

    oIdentify the relationships and cardinalities. (1.5 marks)

    oDesign ER model. (3 marks)

    oSchemas after Normalization (2 marks)

    oCreate the normalized tables. (1.5 marks)

    oPopulate your tables with at least 5 rows. (1.5 marks)

    oExecute 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

    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.

    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.

    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.

    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

    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.

    Retrieve the full name of researchers involved in more than one project along with the number of projects they are part of.

  • Project Introduction to Database

    The first file contains the semester project and its requirements. Only the solutions for points e and f are included. Files 2 and 3 contain student solutions; please refer to them if the solution requires a sequential approach.

  • Project Introduction to Database

    Please review the first file for the semester project and the requirements. I need the solutions for parts 5 and 6. Please adhere to the course syllabus; I will send them. Files 2 and 3 contain student solutions; refer to them if the solution requires a sequential approach.

    *SQL Language

  • Data management

    Course Overview and Introduction to Python for Data Science

    * Python is the most preferred language for data science due to its simplicity, clean syntax, large community, and powerful libraries (NumPy, Pandas, Matplotlib, etc.).

    * The course covers Python fundamentals (variables, data types, loops, conditionals, functions), advanced topics (memory management, file handling, error handling, OOP), and hands-on experience with data science libraries.

    * Python is versatile, used in web development, AI, machine learning, automation, and data analysis.

    * Learning Python by doing is emphasized, starting with basics and progressing to complex projects.

    * Intellipaat offers a comprehensive data science course in collaboration with iHub, IIT Roorkee.

    Python Basics and Concepts

    Python vs Other Languages

    * Python is interpreted (runs line-by-line), making debugging easier.

    * Compiler-based languages translate entire source code at once, are faster in computation but less flexible in debugging.

    * Python is less memory efficient than compiled languages like C, but offers excellent libraries for data science.

    * Pythons libraries (NumPy, Pandas, Scikit-learn, Matplotlib) are unmatched in data science compared to C.

    * Python has strong community support and continuous updates, making it ideal for AI/ML and LLMs (e.g., ChatGPT).

    Variables and Data Types

    * Variables are references to objects in memory; objects have unique IDs.

    * Python supports multiple data types: numeric (int, float, complex), sequential (list, tuple, dictionary, set), and boolean.

    * Variables are case sensitive; naming conventions must be followed (no special characters except underscore, no keywords as variable names).

    * Python allows multiple variable assignment in one line.

    * Global variables are accessible throughout the program, local variables only within their scope.

    Data Types Details

    * Numeric: int (unlimited size), float (decimal numbers), complex (numbers with real and imaginary parts).

    * Sequential:

    List: ordered, mutable, allows duplicates, heterogeneous data.

    Tuple: ordered, immutable, allows duplicates, heterogeneous.

    Set: unordered, mutable, no duplicates.

    Dictionary: key-value pairs, keys unique and immutable, values mutable.

    * Boolean: True/False used in logical operations and control flow

    Lists and Their Operations

    * Lists are fundamental data structures, declared with square brackets.

    *

    * Indexing starts at 0; negative indexing accesses from the end (-1 last element).

    * Slicing syntax: list[start:stop:step] (start included, stop excluded, step default 1).

    * Lists are mutable: elements can be added, updated, or removed.

    * Key list methods:

    append(): adds a single element at the end.

    extend(): adds elements from another iterable.

    insert(index, value): inserts element at a specific position.

    remove(value): removes first occurrence of value.

    pop(index): removes and returns element at index (default last).

    clear(): empties the list.

    sort(): sorts the list in place.

    reverse(): reverses the list in place

    count(value): counts occurrences of value.

    * Copying lists: assignment copies reference; copy() creates shallow copy; deepcopy() creates independent copy.

    * Identity and equality: two lists with same content are equal but have different IDs; small integers are interned (same ID).

  • Using Machine Learning for the design of effective risk mana…

    Designing an AI-Assisted Risk Management Framework for a Chosen Company

    Project Type: Group Project (4 students)

    Deliverables: Technical report as primary file and source code as secondary resource (zip file)

    Weight: 30% of course grade

    >> Project Scenario

    Your group will continue working with the same company or organization you selected in Assignment 2, where you analyzed governance and compliance posture (e.g., a bank, healthcare provider, fintech startup, or government agency). You are now members of the Governance, Risk, and Compliance (GRC) team at the same company you analyzed in Assignment 2. The companys leadership has asked your team to propose a data-driven risk management framework that uses machine learning to enhance the identification, assessment, and prioritization of risks. Your goal is to design an AI-assisted Risk Management System aligned with ISO 27001 family of Standards, NIST Cybersecurity Framework (CSF), and COBIT 2019, while demonstrating how data analytics and ML can enhance risk-based decision-making. The system should demonstrate how predictive analytics can help anticipate risks before they materialize and support better governance and compliance decisions.

    >> Suggested Dataset (Kaggle)

    Please search for each dataset title below on this URL

    e.g. search for Cyber Security Breach Data should result in the following

    and then select the dataset that suits you needs for the selected company.

    – Cyber Security Breach Data 2004 to 2023 (Kaggle)

    – Cybersecurity Attacks Dataset (Kaggle)

    – Risk Assessment Data (Operational Risk Dataset)

    – Credit Risk Data Financial Risk Analysis

    – Malware Detection Dataset

    – Phishing Websites Dataset

    Each group may select the datasets from the above that best aligns with their companys risk domain (cyber, operational, or financial or may be all).

    >> Project Overview

    Your team will apply Machine Learning techniques to analyze risk data and design a framework that supports: Automated risk identification and classification, Quantitative risk scoring or prioritization, Integration of findings into a structured Risk Management Framework and the use of Governance, compliance, and ethical considerations in ML. Further, the framework shall:

    • Identifies and prioritizes risks based on predicted incident likelihood or impact.
    • Integrates outputs into a governance and compliance structure consistent with recognized standards.
    • Demonstrates how ML models can support continuous monitoring and informed decision-making.

    >> Project Structure and Deliverables

    Part I: Framework Design and Governance Alignment

    Objective: Connect risk governance principles and compliance frameworks with your proposed AI-based solution. Establish the organizational and regulatory foundation for the ML-based framework.

    Tasks:

    1.** Revisit the Company Context** Summarize the organizations mission, critical assets, and regulatory environment (e.g., financial sector compliance with PCI DSS, GDPR, etc.). 2. Select Applicable Frameworks Identify relevant standards (e.g., ISO 27001, NIST CSF, COBIT) and map their risk management controls to your companys environment e.g. use the NIST CSF Identify and Protect functions to map their framework controls before integrating ML solutions 3. Define Governance Model Describe how your ML-based risk management framework integrates into the companys governance and reporting structure. 4. Identify Key Risks Use a qualitative matrix (impact likelihood) to define top 510 cyber risks your company faces.

    Part II Machine Learning Application for Risk Assessment

    Objective: Use data-driven techniques to detect, predict, or prioritize cyber risks.

    Tasks:

    1.** Dataset Selection and Preprocessing** – Select one Kaggle dataset (or a subset) relevant to your companys threat profile. – Clean and preprocess data (remove duplicates, normalize, label features).

    1. Model Development
      • Develop at least two ML models(e.g., Decision Tree, Random Forest, Logistic Regression, SVM, or Neural Network).
      • Evaluate model performance (accuracy, precision, recall, F1 score).
    2. Risk Scoring Mechanism
      • Translate ML model outputs into risk scores or probabilities of incidents.
      • Categorize risks into High /Medium / Low tiers aligned with ISO 27005 risk treatment principles.
    3. Integration into Governance Framework
      • Demonstrate how ML outputs would inform the companys risk register,** control selection**, and reporting to management or board committees (e.g. Illustrate this with a flowchart).

    Part III Compliance, Reporting, and Continuous Improvement

    Objective: Demonstrate compliance alignment, reporting, and future scalability.

    Tasks:

    1.** Compliance Mapping** – Map ML-enabled risk monitoring to compliance requirements (e.g., NIST CSF Detect and Respond functions, ISO 27001 Annex A.16 & A.17). – Show how the framework enhances audit readiness and regulatory reporting.

    1. Incident Response and Feedback Loop
      • Propose how the ML system will trigger or support incident response workflows.
      • Integrate continuous learning how data from new incidents can retrain or refine models.
    2. Ethical and Governance Considerations
      • Discuss potential risks of bias, data privacy issues (GDPR relevance), and accountability for automated risk decisions.
      • Suggest controls to ensure transparency and human oversight.

    Final Deliverable

    1. Technical Report (3,0004,000 words): Covers all three parts with analysis, visuals, and citations (50%)
    2. Code Appendix (Secondary Resource): Clean, annotated Python notebook with dataset, preprocessing, model, and results (50%)

    Assignment group

    Assignment Information

    Length:

    4000

    Weight:

    30%

    Learning Outcomes Added

    • : Assess information security vulnerabilities, threats, and risks, for developing an appropriate risk management strategy.
    • : Demonstrate an awareness of the role of the information security policies and programs in organizations, by creating a SETA program for an enterprise
    • : Demonstrate a knowledge of the implementation of information security standards, models, frameworks, compliance and business practices including professional certifications
    • : Design a contingency plan based on risk management.
    • : Deploy machine learning tools to automate risk analysis and treatment