Assignment Lab 1 - Sec 02 (1)

.pdf

School

Conestoga College *

*We aren’t endorsed by this school

Course

PROG8145

Subject

Information Systems

Date

Jun 21, 2024

Type

pdf

Pages

2

Uploaded by AmbassadorHyenaMaster1064

Assignment Lab 01 | 7.5 % of the final Grade Individual Assignment | Due May 31 Used Car Showroom Database Implementation Business Use Case: A used car showroom wants to develop a database system to manage its operations. The system should keep track of cars, customers, sales, employees, and maintenance records. The database will be used to store and retrieve information efficiently and ensure data integrity. Tasks: 1. Identify Tables and Attributes: a. Based on the use case, identify at least five tables required for the used car showroom database. 2. Define appropriate attributes for each table. a. Identify candidate keys and primary keys for each table. 3. Create Tables: a. Write SQL scripts to create the identified tables with the defined attributes, including constraints for candidate keys, primary keys, and foreign keys. 4. Insert Data: a. Insert sample data into each table to represent realistic showroom scenarios. 5. Create Database Diagram: a. Generate a database diagram that includes all the tables and their relationships. 6. Run SELECT Queries: a. Execute SELECT queries to retrieve and display the data from each table. 7. Documentation: a. Include screenshots of the database diagram and the results of your SELECT queries in your submission. Rubric: Task Points Identify tables and attributes 10 Define candidate keys and primary keys 10 Create tables as per the identified schema 20
Assignment Lab 01 | 7.5 % of the final Grade Individual Assignment | Due May 31 Task Points Insert sample data correctly 20 Generate database diagram 20 Run and document SELECT queries 10 Include screenshots of diagram and queries 10 Submission Guidelines : 1. SQL Script : Submit the SQL script used for creating tables and inserting data. 2. Database Diagram : Include a screenshot of the database diagram showing all tables and relationships. 3. SELECT Queries Output : Include screenshots of the results from the SELECT queries for each table. 4. Documentation : Compile all the above components into a single document (Word or PDF) and submit it via the designated platform. 5. Make sure your submission is well-organized and clearly labeled for each part of the assignment.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help