Shared by 
Unlock all 7 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 7 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
$7 one-time payment
- All 7 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
- 7 pages
- Price
- $7 one-time, yours to keep
- Membership
- Included in every plan
- Format
- Subject
- Customer Service, Database Management
- Module
- INF 322 · Week 3
This lab report covers creating, updating, and deleting customer records in a database. It shows SQL queries for managing customer data, and it is for INF 322, Week 3.
What's inside
- Creating customer records with SQL
- Updating customer information
- Deleting customer records
- Displaying customer records in a report
- Identifying primary keys in the customers table
Who it is for: Students taking INF 322, Week 3. (Undergraduate)
Share with classmates: WhatsApp Telegram X LinkedIn Facebook
Summary
Customer service databases are used to store and manage customer information. Students learn how to use SQL code to enter, update and delete customer data in a database.
Entering customer data
SQL code is used to insert customer details into a database table. Customers are added one at a time. Each customer has a unique ID, a company name, a last name and a first name.
Updating customer information
SQL code is used to update customer details in a database table. The update is done for one customer at a time. The customer is identified by their unique ID.
Deleting customer records
SQL code is used to delete a customer record from a database table. The customer is identified by their unique ID. The deletion is confirmed by a message on the relevant row.
Creating a customer report
A report is created to display customer records. The report shows the primary keys for the table. The primary key is the customer's unique ID.
Key terms
- SQL code
- A programming language used to manage and manipulate databases.
- INSERT INTO
- An SQL command to add new data to a database table.
- UPDATE
- An SQL command to modify existing data in a database table.
- DELETE
- An SQL command to remove data from a database table.
- Primary key
- A unique identifier for each record in a database table.
- Customer ID
- The unique identifier for each customer in the database.
Questions this document helps with
- How do you add new customers to a database?
- What SQL command updates customer details?
- How do you delete a customer record from a database?
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.