19 May SQL Statements, MS ACCESS, Due In 8 Hours
You must use the attached file content.
Using the SQL statements provided write CREATE and INSERT statements to populate the ARTIST, GALLERY and PAINTING tables in Microsoft ACCESS. When inserting the data remember that if the data is Text data it should be enclosed in single quotes if it is numeric it will not be enclosed in quotes. Review the examples in chapter 7. You will need to save your Statements in MS Access in the Query view to receive credit for this exercise. I will need to see an INSERT statement for the Artist Table, the Gallery Table and the Painting Table. You will need to insert records into the Parent table before entering records into the child/related table. In addition create 2 new INSERT statements by copying 2 of the existing INSERT statements from each table and change the data and save those INSERT statements with a name of NEW_INSERT_PAINTER_1 , NEW_INSERT_GALLERY_1, NEW_INSERT_PAINTING_1. Increment the 2nd INSERT STATEMENT and save it to the query view pane.
When creating a query in ACCESS do the following
- Click on the Create Menu Button
- Select Query Design
- Depending on which version of Access you have Select SQL View if you have ACCESS 2013
- In older versions select View then SQL View
- Execute your CREATE and INSERT statements and add the data. Review the examples in Chapter 7 on Adding Table Rows for help with writing Insert statements
- Save the Query as
- Add Painter or Artist incrementing each query name by 1 to distinguish one insert from another
- Add Gallery
- Add Painting
- You will insert each record in each table. Again, I emphasize the SQL Statements must be saved in order to get credit. I will test your SQL statements to see if they work. I have included the text file that has both the CREATE and INSERT statements. You will use these in the Query View of SQL to learn to write simple SQL Statements.
Please make sure that you turn on the primary key field. You can do this in ACCESS by going to DESIGN VIEW and click on the row that is the primary key of the table and then go to TOOLS and select primary key.
DELIVERABLES
Do not make this assignment complicated. You are simply copying the text provided and executing the SQL statements and creating 2 new INSERTS for each of the 2 entities. I need you to save 6 INSERT statements total not including the ones provided for this exercise. If you don’t save the statements I will lose a significant amount of points because everything is already provided. You will execute the INSERT statements provided to populate the table but do not save the queries provided for these statements. I already have them. Save only the 6 new queries by modifying the INSERT statements data values to the GALLERY, PAINTER and PAINTING tables.
I have including an attachment name Ch07_Artist_SQL.txt. These are the INSERT Statements you will use in this assignment.
When you have completed the assignment, first close ACCESS and then upload the database to Blackboard. If you don’t close the database before uploading I will not be able to retrieve your files or open the database and I will not receive credit for the exercise.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.