Question: need a SQL project idea with all of the below requirements 1) Provide a description of your sub-system of an organization. Be sure to explain

need a SQL project idea with all of the below requirements 1) Provide a description of your sub-system of an organization. Be sure to explain what function/s the sub-system provides 2) List of tables, description of each table, and their relationships. Be sure to include table name, PK, FK, and datatype for each table. Provide description of the relationships between tables. Make sure you dont have many-to-many relationship. 3) Lucid chart ERD design 4) SQL script export from Lucid chart needs to be in SQL Server script format 5) List of (fake) records/data for you to use for each each of the table. Provide at least 5 records for each table 6) List of SQL scripts to add data/records write the actual SQL script showing how you will insert the data from previous step into database 7) Test out the schema and data using an online resource, such as SQL Fiddle. Include two screenshots (1) a screenshot of successful schema build by pasting exported script from Lucid chart. (2) a screenshot showing successful SQL Run by using a Select statement to retrieve data from a table. 8) Extra credit i. Create a database in SQL Server and name it as PROJECT-DB. Include a screenshot of management studio object explore view showing the created database. ii. Execute the SQL scripts to build tables and insert data. Paste your exported SQL script into the Query and execute to build the tables and insert the data. Include a screenshot of successful query run. iii. Verify DB and tables are created. Verify records are added by issuing Select statements. Include a screenshot showing a successful data retrieval from the tables

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!