Our Services

Get 15% Discount on your First Order

Summary:To apply all acquired knowledge in the last Project Assignments

December 4, 2021

Summary:To apply all acquired knowledge in the last Project Assignments to create a Database Scheme. For this project, the ERD is provided to you.Deliverables:

SQL Script with your name as follows: YourLastName_Project_Ph3.sql.
MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.
ZIP file to include the two files mentioned above.

Required Software:

MySQL DBMS by Oracle. MySQL Community Server and MySQL Workbench.
Follow Step 1-3 for your Course Project Phase phase 1, to install the required software components.

Lab Steps:Step 1: Analyze the ERD for a student information system provided below. Be alert for the specifications provided for: 1) Entities, 2) Attributes, 3) Primary Key, and 4) Relationships. You will need to have a clear understanding for these components to create your database using MySQL. Step 2: Create a New Database in MySQL, Produce SQL File, Drop Table

Create a new Database, as you did in your Course Project Phase 1 deliverable and you already created a database using the MySQL DBMS. Reference the attached video (Course Project Ph1 Video.mp4), for a demonstration to create a new Database using MySQL. This video was initially presented to you for phase 2 of your project. Also, reference the supplemental text: Available for Free download as part of our UC Library. MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill. ISBN: 978-0-07-160550-2. Link to UC Library: http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=nlebk&AN=291311&site=eds-live&ebv=EB&ppid=pp_ii
Utilize the SQL dialect you learned so far in this course for MySQL. Use the file supplemental textbook: MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill, as supplement your knowledge of the MySQL dialect.
Create your SCRIPT file to be named: YourLastName_Project_Ph3.sql.

Step 3: Include the following commands at the tops of your scripts:

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS STUDENT;
DROP TABLE IF EXISTS CAMPUS;
DROP TABLE IF EXISTS ROOM;
DROP TABLE IF EXISTS COURSE;
DROP TABLE IF EXISTS INSTRUCTOR;
DROP TABLE IF EXISTS APPROVED_INSTRUCTOR;
DROP TABLE IF EXISTS CLASS;
DROP TABLE IF EXISTS STUDENT_GRADE;
SET FOREIGN_KEY_CHECKS=1;

Step 4: Create Tables in your database

Create a new Table for each of the entities provided to you in the ERD diagram in Step 1.
Add a column to represent each attribute addressed in the ERD diagram in Step 1.
Designate Primary Key, as noted in the ERD diagram in Step 1.
Designate a Foreign Key relationship between the tables, as noted in the ERD diagram in Step 1.
Enable referential integrity on the relationships, as needed.
Enable cascade updates as needed on the relationships.

Step 5: Designate Data Types. Update the data type as needed to enforce the domain constrain of the data. This needs to be completed for every column for all tables.

Dates: they should have a date data designation type.
Surrogate keys: shall be auto-numbered
Character type: shall have a character data designation type.

Step 6: Column Constraints Designation.

Grade designation must be of one of these values as follows: A, B, C, D, E, F, W, E (E=enrolled, and W = withdrawn).
Student’s first and last names are not to be designated as NULL.
Course Credit hours shall be BETWEEN one and four.
The instructor first and last name must NOT be NULL
Course name designation has to be UNIQUE and must not be NULL type.

Step 7: Data Table Addition

Use the INSERT operator to add minimum 2-3 rows of data per each database.
You are free to use any values you might like for each of the columns.
NOTE/ Reminder: you are required to add data to the parent table prior to adding any data to child tables, as referential integrity is enabled.

Step 8: Executing your SCRIPT

Must incorporate the COMMIT command at the end of your Script
Must incorporate the SHOW TABLES command, to display the table you created. At the end of the script created.
Must incorporate the SELECT statement to show data allocated for each table. This would be added at the end of the script.
EXECUTE your SCRIPT.
Copy and paste your OUTPUT into your MS Word file as follows: YourLastName_Project_Ph3_Output.doc

Step 9: Upload your work

Upload ZIP file to include the two files as follows: 1) SQL Script with your name as follows: YourLastName_Project_Ph3.sql, and 2) MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.

Rubric:

Tables Created: create a table for each entity as noted in the ERD diagram in Step 1. 5 points
Columns Created: create a column for each attribute as noted the ERD diagram in Step 1. 5 points
Primary Key designation: primary key addressed for all tables with unique constraints specified as column properties. 5 points
Data Types: Addressed for each attribute. Should include: 1) Date data type incorporated, 2) Surrogate Key Automated, 3) Numeric data shall be numeric type, 4) Character data shall have a character type. 5 points
Relationships Created, as noted in the ERD diagram in STEP 1. Relationships shall be enabled for referential integrity and cascade updates. 10 points.
Data Added per row: 5 rows of data for each table. 10 points
Column Constraints Added: As noted in the description for the project. Checked by adding rows with invalid values. Should take into consideration constraints as follows: 1) student name cannot be NULL, 2) course credit hours are restricted to allocations between 1-4, 3) course name is unique and NOT NULL, 4) instructor last name and first name can NOT be NULL, and 5) grade restrictions to the following values: A,B,C,D,F,I,W, E. 10 points

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Professional Nursing Membership

Oncology Nurse Society-ONS or the ANA Examine the importance of professional associations in nursing. Choose a professional nursing organization that relates to your specialty area, or a specialty area in which you are interested. In a 750-1,000 word paper, provide a detailed overview the organization and its advantages for members.

Your former Professor, the Director of Global Sourcing and Importing

Your former Professor, the Director of Global Sourcing and Importing for an overseas company, is looking to export a product to another country. The company is expanding their international trade by finding new sources of foreign products. They are considering Canadian products and would like you to structure one of

Consider this a practice assignment and focus on content, not

Consider this a practice assignment and focus on content, not formatting. Your paper should be no more than two pages in length. For this activity: Create a severance package for a separated employee in a fictitious company that includes position differences, years of service, actual compensation amounts, and any additional

Various agencies contribute to the social services offered in social

Various agencies contribute to the social services offered in social work practice. Although the goal of many social work agencies may appear the same—to offer social services to clients who need them—each agency provides a unique approach or opportunity to deliver those needs. As a future social worker, understanding

Use this week’s discussion to reflect on the use of

Use this week’s discussion to reflect on the use of files and rasps by answering the following prompt. When is it appropriate to use a file versus a stone? What are the most common types of files for use with metal? Can we use a bastard cut file on

documentary on youtube – Hamilton: Building America Full episode Link: www.youtube.com/watch?v=XsvP4WRIUB4&t=16s The grading for the Research Project will

documentary on youtube – Hamilton: Building America Full episode Link: www.youtube.com/watch?v=XsvP4WRIUB4&t=16s The grading for the Research Project will be divided into Format and Content Format’s Rubric This part of the essay is worth 60 points After watching the documentary “Hamilton”, write an essay as follow: 1-Your Essay must be at

Select a piece of Informational text and Narrative text (both

Select a piece of Informational text and Narrative text (both developmentally appropriate). Prepare discussion questions that will involve your student’s child in literal and critical thinking. Your assignment should be set up like this: Title of Informational text, author A brief summary of the text 5 literal questions 5 inferential and critical

STUDY PLAN Can you imagine an athlete deciding to run a Nursing Assignment Help

STUDY PLAN Can you imagine an athlete deciding to run a marathon without training for the event? Most ambitious people who have set this goal will follow a specific training plan that will allow them to feel confident and prepared on the big day. Similarly, if you want to feel

Read the background info on the soucouyant, available here: https://horrorpedia.com/2015/01/08/soucouyant-folklore/

Read the background info on the soucouyant, available here: https://horrorpedia.com/2015/01/08/soucouyant-folklore/ Pay attention to the specific attributes of the soucouyant, and consider how this creature is and is not like the vampire of European folklore. The figure of the soucouyant still lives in Caribbean culture, and many Caibbean authors have referenced the

References: At least two sources are required, and at least one must come from the CSU Online Library. Both sources should be academically credible

References: At least two sources are required, and at least one must come from the CSU Online Library. Both sources should be academically credible (academic journals, eBooks, periodicals, organizational websites, etc.) and no more than 5 years old. Use APA Style 7th edition standards to format the reference citations for

Final At the end of your textbook on page 385,

Final At the end of your textbook on page 385, the author mentions several “encouraging security architecture developments”: The Open Group has created an Enterprise Security Architect certification. One of their first certified architects has subsequently created a few enterprise security reference architectures. The SANS Institute hosted three “What

HSM 410 Entire Course Nursing Assignment Help

This pack of HSM 410 Entire Course includes: HSM 410 Week 1 DQ 1 What is Healthcare Policy HSM 410 Week 1 DQ 2 Foreign Healthcare HSM 410 Week 2 Course Project HSM 410 Week 2 DQ 1 U.S. Healthcare System Organization HSM 410 Week 2 DQ 2 Financing A

Case Study, 1. June Frankel, a 23-year-old patient, presents to

Case Study, 1. June Frankel, a 23-year-old patient, presents to the emergency department with a sports-related fracture injury to her right arm and receives a long-arm fiberglass cast. (Learning Objective 2) What nursing assessment should the nurse provide after the cast has been applied? What nursing interventions should the nurse

· Address the following prompts. · Prompt 1: In the section “Taking the Project Management Route”, the team is developing a schedule for

· Address the following prompts. · Prompt 1: In the section “Taking the Project Management Route”, the team is developing a schedule for the overall project. Discuss how a network diagram might come in handy for this task. What does the critical path have to do with this approach? Use

Using the Internet or Strayer Library, research the articles about

Using the Internet or Strayer Library, research the articles about Fraud Prevention and Detection Technology. Evaluate the various tools / techniques available to auditors to prevent or detect fraud. Based on your analysis, propose the most effective audit tools / techniques that would have prevented or detected the fraud. Support your

Students need clarification to ask for help with dissertation writing.

Students need clarification to ask for help with dissertation writing. They’re too confused about that, but if you ask me how, ask for help with dissertation writing if you can’t think of a topic for the dissertation. Don’t hesitate to ask for help from your sibling, friends, and others. Visit

Corporate diversification strategies raise a wide range of strategic management

Corporate diversification strategies raise a wide range of strategic management issues. For this week’s critical thinking, read the case study found in your textbook: Case 16: Manchester City: Building a Multinational Soccer Enterprise, p.554 (in the textbook). Remember, a case study is a puzzle to be solved, so before reading and

Discuss the importance of differentiated instruction for meeting the academic needs of gifted and talented students. Discuss the benefits and

Discuss the importance of differentiated instruction for meeting the academic needs of gifted and talented students. Discuss the benefits and limitations of using differentiated instruction in the classroom to cater to the diverse abilities and learning styles of these students. Provide a mock scenario where you design a differentiated instruction