Question: I need help with this assignment, please help me. INFO 2630 - Structured Query Language PROJECT 50 points. OPTION A SQL Build a database of
I need help with this assignment, please help me.
INFO 2630 - Structured Query Language PROJECT 50 points. OPTION A SQL Build a database of your choosing, using MySQL or SQL SERVER. Place all of your commands into one script file named project.sql. . Your project will include a one to two-page summary of your database. Save your summary as summary.doc. Minimum requirements include: *Creating a database *Creating a new user *At least three tables with appropriate keys and constraints (3-5 records in each table is sufficient) *Indexes as appropriate *Multiple-table queries (using joins) (use at least three types of joins) *Subqueries (at least three) *Grouping and ordering (at least two of each) *Updating tables (at least two updates to existing data) *Revisions to a table's structure (at least two) *Functions (one character function, one numeric function, and one date function) *Views (at least two) Turn in the following files: Your script fileproject.sql A one to two page summary of your databasesummary.doc. Create a ZIP archive containing these files and turn in your ZIP archive.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
