Open navigation menu
Close suggestions
Search
Search
en
Change Language
Upload
Loading...
User Settings
close menu
Welcome to Scribd!
Upload
Read for free
FAQ and support
Language (EN)
Sign in
0 ratings
0% found this document useful (0 votes)
4 views
Ychavenia
Uploaded by
kenshley
Copyright:
© All Rights Reserved
Available Formats
Download
as DOCX, PDF, TXT or read online from Scribd
Download
Save
Save Ychavenia For Later
0%
0% found this document useful, undefined
0%
, undefined
Embed
Share
Print
Report
Ychavenia
Uploaded by
kenshley
0 ratings
0% found this document useful (0 votes)
4 views
1 page
Document Information
click to expand document information
Copyright
© © All Rights Reserved
Available Formats
DOCX, PDF, TXT or read online from Scribd
Share this document
Share or Embed Document
Sharing Options
Share on Facebook, opens a new window
Facebook
Share on Twitter, opens a new window
Twitter
Share on LinkedIn, opens a new window
LinkedIn
Share with Email, opens mail client
Email
Copy link
Copy link
Did you find this document useful?
0%
0% found this document useful, Mark this document as useful
0%
0% found this document not useful, Mark this document as not useful
Is this content inappropriate?
Report
Copyright:
© All Rights Reserved
Available Formats
Download
as DOCX, PDF, TXT or read online from Scribd
Download now
Download as docx, pdf, or txt
Save
Save Ychavenia For Later
0 ratings
0% found this document useful (0 votes)
4 views
1 page
Ychavenia
Uploaded by
kenshley
Copyright:
© All Rights Reserved
Available Formats
Download
as DOCX, PDF, TXT or read online from Scribd
Save
Save Ychavenia For Later
0%
0% found this document useful, undefined
0%
, undefined
Embed
Share
Print
Report
Download now
Download as docx, pdf, or txt
Jump to Page
You are on page 1
of 1
Search inside document
Fullscreen
Chavenia, Yezza Mhae U.
BSIT - III
Data Administration
CREATE TABLE students ( ('Ryan', 'Villalon', 'Web Development');
studentsID INT AUTO_INCREMENT PRIMARY
KEY, INSERT INTO courses (course_name,
fname VARCHAR(255), course_code) VALUES
lname VARCHAR(255), ('Data Administration', 'CS101'),
average DECIMAL(5, 2) ('Programming', 'CS102'),
); ('Visual Arts', 'ART101'),
('Research', 'RES101'),
CREATE TABLE teachers ( ('Web Development', 'WD101');
teachersID INT AUTO_INCREMENT PRIMARY
KEY, INSERT INTO enrollments (studentsID,
fname VARCHAR(255), teachersID, coursesID, grade) VALUES
lname VARCHAR(255), (5, 1, 5, 93.5),
subjects VARCHAR(255) (4, 1, 5, 93.4),
); (4, 2, 4, 93.5),
(2, 3, 3, 94.3),
CREATE TABLE courses ( (2, 5, 3, 94.3),
coursesID INT AUTO_INCREMENT PRIMARY (3, 4, 2, 94.3),
KEY, (1, 4, 2, 94.3),
course_name VARCHAR(255), (1, 5, 1, 95.5);
course_code VARCHAR(255)
); SELECT fname, lname, 'Web Development' AS
course_name
CREATE TABLE enrollments ( FROM students
enrollmentsID INT AUTO_INCREMENT WHERE studentsID IN (
PRIMARY KEY, SELECT studentsID
studentsID INT, FROM enrollments
teachersID INT, WHERE coursesID = 5
coursesID INT, );
grade DECIMAL(5, 2),
FOREIGN KEY (studentsID) REFERENCES SELECT * FROM teachers
students (studentsID), WHERE subjects='programming';
FOREIGN KEY (teachersID) REFERENCES
teachers (teachersID), SELECT * FROM enrollments
FOREIGN KEY (coursesID) REFERENCES WHERE coursesID=2;
courses (coursesID)
);
INSERT INTO students (fname, lname, average)
VALUES
('Jennelle', 'Arrogancia', 93.5),
('Dominique', 'Aquino', 93.5),
('Nicole', 'Marquez', 94.3),
('Angel', 'Latchica', 94.3),
('Jayvee', 'Crujido', 95.5);
INSERT INTO teachers (fname, lname, subjects)
VALUES
('Ryan', 'Villalon', 'Data Administration'),
('Jhunel', 'Penaflorida', 'Programming'),
('Jonathan', 'Marquez', 'Visual Arts'),
('Honesto', 'Camino', 'Research'),
('Angelo', 'Pera', 'Programming'),
You might also like
Blazor and API Example: Classroom Quiz Application
From Everand
Blazor and API Example: Classroom Quiz Application
Taurius Litvinavicius
No ratings yet
Reporting and Analysis
Document
171 pages
Reporting and Analysis
Chandan Mishra
No ratings yet
Untitled Document
Document
4 pages
Untitled Document
arvindpuri1492
No ratings yet
Section One PROJECT ANSWER
Document
6 pages
Section One PROJECT ANSWER
Esubalew
No ratings yet
Lecture1&2
Document
6 pages
Lecture1&2
abulkhayermondol30
No ratings yet
Assignment - 2
Document
3 pages
Assignment - 2
Sandra Kaveesher
No ratings yet
EXP2
Document
2 pages
EXP2
anu1529ravina
No ratings yet
CMJD Class Note 01 - Database Management Systems
Document
8 pages
CMJD Class Note 01 - Database Management Systems
MUSIC & TECH
No ratings yet
DBMS Prac. Complete
Document
40 pages
DBMS Prac. Complete
ubantumalik2
No ratings yet
Lecture 8
Document
12 pages
Lecture 8
alanmox441
No ratings yet
20234103222_lab2
Document
3 pages
20234103222_lab2
Arifur Rahman
No ratings yet
Dms Code
Document
4 pages
Dms Code
kishorgaikar876
No ratings yet
202251062_DBMS_WEEK6
Document
13 pages
202251062_DBMS_WEEK6
Kanzariya Akshay kanaiyalal
No ratings yet
Abhinav DBMS File
Document
15 pages
Abhinav DBMS File
Aditi Singh
No ratings yet
University Database Creation
Document
6 pages
University Database Creation
Rajasekhar Reddy Gontu
No ratings yet
4
Document
2 pages
4
jhonrowmelgualvez1
No ratings yet
Suico - Lab - Act - 1
Document
4 pages
Suico - Lab - Act - 1
Precious Lyn Suico
No ratings yet
Aggregate Functions ROLL NO: 71762303 114 Name: Shavya S S
Document
4 pages
Aggregate Functions ROLL NO: 71762303 114 Name: Shavya S S
appathangam.2006
No ratings yet
DBMSLAB (1)
Document
14 pages
DBMSLAB (1)
souravm.it.23
No ratings yet
CSU 07314 Practical #6_2024 SQL
Document
3 pages
CSU 07314 Practical #6_2024 SQL
abasichay1
No ratings yet
L06
Document
8 pages
L06
nazmussadiq
No ratings yet
l226557 Result FILE
Document
5 pages
l226557 Result FILE
l226557
No ratings yet
SQL Sample (2)
Document
1 page
SQL Sample (2)
areteshephaestus
No ratings yet
ACTIVITY Stored Procedures Triggers 2R3 Baluran
Document
6 pages
ACTIVITY Stored Procedures Triggers 2R3 Baluran
Marc Aga Baluran
No ratings yet
Controle db2
Document
2 pages
Controle db2
meddservice1
No ratings yet
SQL Report
Document
10 pages
SQL Report
Swet Sheersh
No ratings yet
NUT Removed
Document
6 pages
NUT Removed
Prateek Tiwari
No ratings yet
Univesity Management System Databasee
Document
4 pages
Univesity Management System Databasee
Holyy Salsa
No ratings yet
joins
Document
1 page
joins
Suresh
No ratings yet
SSP1
Document
2 pages
SSP1
kingbalaji81
No ratings yet
Creates Consultasql3
Document
2 pages
Creates Consultasql3
douglasgobitsch
No ratings yet
E-Learning WEB PROJECT
Document
12 pages
E-Learning WEB PROJECT
Bhavesh K
No ratings yet
Day 4
Document
4 pages
Day 4
anshkanch
No ratings yet
FA22-BCS-263-DatabaseLab Assign4 21 5 24
Document
9 pages
FA22-BCS-263-DatabaseLab Assign4 21 5 24
extra83331
No ratings yet
Labtest 2
Document
3 pages
Labtest 2
Fawad Amazon
No ratings yet
College Admission
Document
7 pages
College Admission
abhrajitmukherjee799
No ratings yet
R Lab Programs
Document
19 pages
R Lab Programs
mdqhizar1211125
No ratings yet
Testpripremabaze 1
Document
3 pages
Testpripremabaze 1
cecisol994
No ratings yet
Primary Key
Document
34 pages
Primary Key
Likith SR
No ratings yet
Tugas Basis Data
Document
9 pages
Tugas Basis Data
lely monalisa
No ratings yet
New
Document
2 pages
New
api-529013966
No ratings yet
DBAM Lab 2
Document
12 pages
DBAM Lab 2
f2022105208
No ratings yet
Tutorial 1 Database Practice:: Data Type Format Description
Document
3 pages
Tutorial 1 Database Practice:: Data Type Format Description
Rifat_mmu
No ratings yet
Sample SQL Manual
Document
3 pages
Sample SQL Manual
amsalu azanaw
No ratings yet
SQL Table
Document
5 pages
SQL Table
DeepakKattimani
0% (1)
Database
Document
6 pages
Database
Ghulam Fareed
No ratings yet
ISC 305 Assignment
Document
3 pages
ISC 305 Assignment
annmell921
No ratings yet
Arranged by Nur Rizal (4101418097)
Document
7 pages
Arranged by Nur Rizal (4101418097)
noer_rizal
No ratings yet
Data_Handling_Visualization_Management_Solutions_Color_Coded
Document
4 pages
Data_Handling_Visualization_Management_Solutions_Color_Coded
kotasthaneananya
No ratings yet
Term 2 Practical List CLASS XII CBSE 2021-22
Document
5 pages
Term 2 Practical List CLASS XII CBSE 2021-22
ansh.rai699544
No ratings yet
Student_Management_System_Project
Document
4 pages
Student_Management_System_Project
dadu27973
No ratings yet
Triggers
Document
8 pages
Triggers
Deepa Deepa
No ratings yet
Dbms20222-M14-A1-11-Rizkysuryaalfarizy - (SQL Oracle Developer)
Document
14 pages
Dbms20222-M14-A1-11-Rizkysuryaalfarizy - (SQL Oracle Developer)
Rizky Surya
No ratings yet
北京共立康桥计算机技术有限公司
Document
5 pages
北京共立康桥计算机技术有限公司
842043024
No ratings yet
IMSE 685 Manufacturing Information Systems Homework Assignment #3
Document
11 pages
IMSE 685 Manufacturing Information Systems Homework Assignment #3
MARYAM shah
No ratings yet
CREATE DATABASE akademik;
Document
1 page
CREATE DATABASE akademik;
Imam Arifin
No ratings yet
DBMS with NO Sql Lab
Document
5 pages
DBMS with NO Sql Lab
21mca28mahakaviyarasi
No ratings yet
Dbms
Document
3 pages
Dbms
Akashdeep Singh
No ratings yet
The Data.: Question 1: Create A Table Insert Records and Manipulate
Document
32 pages
The Data.: Question 1: Create A Table Insert Records and Manipulate
SSC CHSL
100% (1)
CS 2024 MS Practical
Document
3 pages
CS 2024 MS Practical
tony stark
No ratings yet
Untitled
Document
18 pages
Untitled
Ganesh Nitalikar
No ratings yet
Functional Dependency
Document
58 pages
Functional Dependency
Krishna Vaitinadin
No ratings yet
9i SQL Slide
Document
141 pages
9i SQL Slide
api-3698230
100% (1)
Review Questions 3
Document
3 pages
Review Questions 3
Wajiihah Baureek
No ratings yet
Data Base Normalization and ERD
Document
23 pages
Data Base Normalization and ERD
sxurdc
No ratings yet
Normalization Assessment Solutions PDF
Document
3 pages
Normalization Assessment Solutions PDF
Ayushi Jangpangi
No ratings yet
Logical Database Design Principles 1st Edition John Garmany 2024 Scribd Download
Document
60 pages
Logical Database Design Principles 1st Edition John Garmany 2024 Scribd Download
daffylemera1
100% (12)
Relational Model and SQL: Alvin Cheung Aditya Parameswaran
Document
54 pages
Relational Model and SQL: Alvin Cheung Aditya Parameswaran
Mohamed Abdelhamid
No ratings yet
Introduction of Database Normalization
Document
26 pages
Introduction of Database Normalization
Om Sirsath
No ratings yet
DBMS
Document
2 pages
DBMS
Silvia Mukhopadhyay
0% (1)
231867-06 B Pascal Arrays Function Prosidures and Paradime
Document
9 pages
231867-06 B Pascal Arrays Function Prosidures and Paradime
Joseph Daniel
100% (1)
E21 Quest Set2
Document
9 pages
E21 Quest Set2
Logesh Logesh
No ratings yet
Practical Question Bank
Document
6 pages
Practical Question Bank
Shaurya Nikam
No ratings yet
C02 Data - Models WEEK 2 PDF
Document
57 pages
C02 Data - Models WEEK 2 PDF
Ainil Hawa
No ratings yet
Database Mid Term
Document
13 pages
Database Mid Term
mamdouhbevnoty
No ratings yet
r24 Dbms Lab Manual
Document
133 pages
r24 Dbms Lab Manual
hemakesaven.taksha
No ratings yet
Hibernate Mapping and Inheritance Annotations
Document
57 pages
Hibernate Mapping and Inheritance Annotations
Sayyed Sameena
No ratings yet
Simple and Complex Queries
Document
31 pages
Simple and Complex Queries
Har Jad
No ratings yet
DBMS Entity-Relationship (E-R) Data Model
Document
8 pages
DBMS Entity-Relationship (E-R) Data Model
RayO19
No ratings yet
List of SQL Commands
Document
7 pages
List of SQL Commands
txungo
100% (2)
Notes of Unit - 6 (DBMS)
Document
8 pages
Notes of Unit - 6 (DBMS)
28julykarnsoumya
No ratings yet
DBMS_Fill in the Blanks
Document
3 pages
DBMS_Fill in the Blanks
hamdaeshk09
No ratings yet
Assignment 2: To Convert ER Diagram To Relational Schema
Document
16 pages
Assignment 2: To Convert ER Diagram To Relational Schema
Ashish Sharma
No ratings yet
Name Null? Type Emp - No Not Null Number (5) Last - Name VARCHAR2 (10) Dept - No Not Null Number (5) Salary NUMBER (6,2)
Document
22 pages
Name Null? Type Emp - No Not Null Number (5) Last - Name VARCHAR2 (10) Dept - No Not Null Number (5) Salary NUMBER (6,2)
ulrich nobel kouamé
No ratings yet
RSDB En-Us SG M06 Databasesintro
Document
23 pages
RSDB En-Us SG M06 Databasesintro
michellekangethe
No ratings yet
2nd Year Test 4th Chapter
Document
1 page
2nd Year Test 4th Chapter
Qazi Salman Sajid (IUB)
No ratings yet
2nd Exam
Document
16 pages
2nd Exam
Martzel Pelicano Baste
100% (1)
New DBMS Lab - Course Plan 2014
Document
16 pages
New DBMS Lab - Course Plan 2014
UjjWal MahAjan
No ratings yet
Kalido Generic Data Modeling
Document
23 pages
Kalido Generic Data Modeling
smritijolly
No ratings yet
Sistema de Identificaqcion
Document
341 pages
Sistema de Identificaqcion
FabiánHurtado
No ratings yet