Scribd
Upload
12 views8 pages

Database Project: ERD & SQL Commands

The document outlines a project in the Fundamentals of Database course submitted by Juan Dela B. Cruz. It includes components such as an ERD diagram, class diagram, designer view, and various SQL commands categorized into Data Definition Language, Data Manipulation Language, and Data Query Language. Specific SQL queries demonstrate different conditions and operations like 'OR', 'AND', 'ORDER BY', and 'INNER JOIN'.

Uploaded by

sabilaoronald
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
12 views8 pages

Database Project: ERD & SQL Commands

The document outlines a project in the Fundamentals of Database course submitted by Juan Dela B. Cruz. It includes components such as an ERD diagram, class diagram, designer view, and various SQL commands categorized into Data Definition Language, Data Manipulation Language, and Data Query Language. Specific SQL queries demonstrate different conditions and operations like 'OR', 'AND', 'ORDER BY', and 'INNER JOIN'.

Uploaded by

sabilaoronald
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Project in

Fundamentals of Database

(Database Title)

Submitted by:
Juan Dela B. Cruz
BSIT 2

Submitted to:
Kevin Roy C. Jaldo
Instructor
1. ERD Diagram
2. Class Diagram
3. Designer View
4. SQL Command
A. Data Definition Language (for every Database and tables)

B. Data Manipulation Language (For every tables)

C. Data Query Language (at least 2 from different table)


1) “OR” Condition

2) “AND” Condition

3) Combination of “OR” and “AND”

4) ORDER BY

5) LIMIT

6) IN
7) LIKE %

8) COUNT

9) BETWEEN

10)INNER JOIN

You might also like