IUG Database Systems

@IUG-Database-Systems

IUG Database Systems

Private team

Joined on Feb 6, 2023

  • Database Systems Pre-Lab 8 Part II JDBC Part II [Storing Binary Data] The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/04/16 Storing Binary Data Introduction PostgreSQL provides two distinct ways to store binary data. Binary data can be stored in a table using the data type bytea or by using the Large Object feature. But in order to determine which method is appropriate for you, you need to understand the limitations of each method.
     Like  Bookmark
  • Database Systems Lab 8 JDBC Part 2 The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/24 Expecteed outcomes To be familiar with JavaFX, build first FXML application with user interfaces for manipulating data. To explore more about JDBC API statements and resultsets. Lab 8: Time and Plan Tasks
     Like  Bookmark
  • Database Systems Pre-Lab 8 Part I JDBC Part II The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/04/16 Expecteed outcomes To be familiar with JavaFX, build first FXML application with user interfaces for manipulating data. To explore more about JDBC API statements and resultsets. Lab 8: Time and Plan Tasks
     Like  Bookmark
  • Database Systems Lab 6 Part II Triggers The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/04/04 Expecteed outcomes To be introduced to Database Triggers commands and concepts. To learn how to create and delete Triggers in PostgreSQL. To learn how to use Triggers in PostgreSQL. Lab 5: Time and Plan
     Like  Bookmark
  • Database Systems Pre-Lab 6 Part II Triggers The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/04/04 Expecteed outcomes To be introduced to Database Triggers commands and concepts. To learn how to create and delete Triggers in PostgreSQL. To learn how to use Triggers in PostgreSQL. Lab 5: Time and Plan
     Like 1 Bookmark
  • Database Systems Pre-Lab 7 JDBC Part I The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/04/16 Expecteed outcomes Learning how to connect to the PostgreSQL database server from a Java program [Intellij]. To be familiar with JDBC library statements to execute queries and updates. To build organized and meaningful outputs from resultsets and metadata. Lab 7: Time and Plan
     Like  Bookmark
  • Database Systems Lab 7 JDBC Part 1 The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/24 Expecteed outcomes Learning how to connect to the PostgreSQL database server from a Java program [Intellij]. To be familiar with JDBC library statements to execute queries and updates. To build organized and meaningful outputs from resultsets and metadata. Lab 7: Time and Plan
     Like  Bookmark
  • Database Systems Lab 6 Part I Functions & procedures The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/24 Expecteed outcomes To be introduced to Database Functions commands and concepts. To learn how to create and delete different types of Functions in PostgreSQL. To learn how to use Functions in PostgreSQL. Lab 5: Time and Plan
     Like  Bookmark
  • Database Systems Project 01 Students Attendance The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/04/05 Deadline: 11:59 PM, 26th May, 2023 Female discussion Date: 27th May, 2023 Male discussion Date: 28th May, 2023 Goal The goal of this project is to provide a realistic experience in the conceptual design, logical design, implementation, and operation of a relational database applications.
     Like  Bookmark
  • Database Systems Pre-Lab 6 Part I Functions & procedures The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/24 Expecteed outcomes To be introduced to Database Functions commands and concepts. To learn how to create and delete different types of Functions in PostgreSQL. To learn how to use Functions in PostgreSQL. Lab 5: Time and Plan
     Like  Bookmark
  • Database Systems Lab 5 Intermediate SQL The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/17 Expecteed outcomes To be introduced to Database Authorization commands and concepts. To learn how to define, alter, and use Views and Materialized Views in PostgreSQL. To practice working with dates in SQL. To learn how to import CSV file into a PostgreSQL table.
     Like 1 Bookmark
  • Database Systems Pre-Lab 5 Intermediate SQL The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/16 Expecteed outcomes To be introduced to Database Authorization commands and concepts. To learn how to define, alter, and use Views and Materialized Views in PostgreSQL. To practice working with dates in SQL. To learn how to import CSV file into a PostgreSQL table.
     Like  Bookmark
  • Database Systems Lab 5 Intermediate SQL(More Questions) The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/17 More Questions Come up with a scenario in which you will need to revoke a privilege from public. The university rules allow an F grade to be overridden by any pass grade (A, B, C, D). a. create a view that lists information about all fail grades that have not been overridden (the view should contain all attributes from the takes relation). b. Find all students who have 2 or more non-overridden F grades as per the takes relation, and list them along with the F grades. Trying more view operations:
     Like  Bookmark
  • Database Systems Pre-Lab 4 More SQL The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/06 Expecteed outcomes To be familiar with all types of joins in SQL. To practice writing and understanding queries that employ subqueries. To use your newly acquired knowledge to write rich and complex DML. To familiarize yourself with Dates in SQL.
     Like 1 Bookmark
  • Database Systems Lab 4 More SQL The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/07 Expecteed outcomes To be familiar with all types of joins in SQL. To practice writing and understanding queries that employ subqueries. To use your newly acquired knowledge to write rich and complex DML. To familiarize yourself with Dates in SQL.
     Like  Bookmark
  • Database Systems Lab 4 More SQL The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/07 Expecteed outcomes To be familiar with all types of joins in SQL. To practice writing and understanding queries that employ subqueries. To use your newly acquired knowledge to write rich and complex DML. To familiarize yourself with Dates in SQL.
     Like  Bookmark
  • Database Systems Lab 4 More SQL The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/07 Expecteed outcomes To be familiar with all types of joins in SQL. To practice writing and understanding queries that employ subqueries. To use your newly acquired knowledge to write rich and complex DML. To familiarize yourself with Dates in SQL.
     Like  Bookmark
  • Database Systems Lab 4 More SQL(More Questions) The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/03/07 More Questions Display a list of all instructors (names and IDs), for each instructor show the number of physics courses he taught. Make sure to show the number of course as 0 for instructors who have not taught any physics courses.Do it without a subquery. Do it using a subquery. Find the enrollment across all sections, but now also include sections with no students taking them; the enrollment for such sections should be treated as 0. Do this in two different ways (and create required data for testing).
     Like  Bookmark
  • Database Systems Lab 4 Basic SQL The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/02/07 Expecteed outcomes To be introduced to the supported and most used data types in PostgreSQL. To be familiar with syntax and semantic rules of PostgreSQL constructs. To practice SQL basics. To build different structured queries for given natural language queries.
     Like  Bookmark
  • Database Systems Lab 3 Basic SQL(More Questions) The Islamic University of GazaEngineering FacultyDepartment of Computer Engineering Authors: Usama R. Al Zayan & Rasha E. Kahil2023/02/07 More Questions Create a table: secretaries (id, name, dept_name, salary), your primary key field have to be generated and incremented automatically when a new record is inserted into the table. Test your work by inserting data to the created table (3 rows). On our uni-largeSpace schema execute quires to find the following. Include both your query and the results in your lab report. Find names of all students who have not taken any Computer Science course. (Should be no duplicate names). Find names of all departments that have at least one Design course, whose title starts or ends with “Design”.
     Like 1 Bookmark