Shared by 
Unlock all 4 pages
Get it free by sharing your own notes, buy just this one, or become a member and unlock documents with your plan.
How to unlock this document
Choose the way that suits you. Each one gives you all 4 pages to read online and the PDF to download.
Share your notes, unlock for free
2 free unlocks for every 5 approved uploads
- Upload your own lecture notes, assignments, essays or past papers
- PDF, Word, PowerPoint and Excel files all work, and you can send many at once
- We check each upload; you get a notification when it is approved
- Spend a free unlock on this document or any other, and keep it for good
- Shared under your public username, never your email
Then upload your notes from your profile.
Buy this document
$4 one-time payment
- All 4 pages of this document, yours to keep
- Download the PDF and read it any time, also offline
- No subscription and nothing to cancel
- Find it again any time under My Profile → Library
You log in or create a free account first, then pay securely.
Become a member
Unlock documents from the whole library, which keeps growing
- Choose any documents you like, up to your plan’s unlocks
- Documents you unlock stay yours, even if you cancel later
- Your unlocks start again with every renewal
- Secure checkout by Dodo Payments
You log in or create a free account first, then pay securely.
Compare the plansAlready a member, or bought this before? Log in to open it
About this document
- Pages
- 4 pages
- Price
- $4 one-time, yours to keep
- Membership
- Included in every plan
- Format
- Subject
- Computer Science, Information Technology
- Module
- INF322 · Week 1
This lab report covers the creation of a database and a table using SQL queries. It includes screenshots of the queries and their results. It is useful for students of INF322 in Week 1.
What's inside
- Creating a database
- SQL code for creating a database
- Creating a table
- SQL code for creating a table
- Screenshots of queries and results
Who it is for: Students of INF322 Database Management Systems in Week 1. (Undergraduate)
Share with classmates: WhatsApp Telegram X LinkedIn Facebook
Summary
Database management systems are used to store and manage data. Students learn how to create a database and a table using SQL commands.
Creating a database
A database is a collection of data. Students follow steps to create a database named CALDWELL using SQL code.
Creating a table
A table is a structured way to store data. Students write SQL code to create an Employee table with several columns.
Table columns
Columns are the fields in a table. Students list the columns for the Employee table and their data types.
Primary key
A primary key is a unique identifier. Students set the id column as the primary key for the Employee table.
Key terms
- SQL
- A language used to communicate with databases.
- Database
- A collection of data stored in a computer system.
- Table
- A structured way to store data in a database.
- Column
- A field in a table that holds a certain type of data.
- Primary key
- A unique identifier for each record in a table.
- Data types
- The kind of data that can be stored in a column.
Questions this document helps with
- What is a database and how is it created?
- How do you structure data in a database?
- What makes a primary key important in a table?
Summary written with AI from the document's text.
Ask the AI Teacher
Ask any question about this document or your course, and get a clear explanation.
Log in to ask Create a free account
Free accounts can ask 5 questions a day.