Homework Questions? Ask a Tutor for Answers ASAP
Database: Select an organization of your choice. Some ideas might be a small business, local government, or a nonprofit organization. Alternatively, you may use a Virtual Organization found on the Virtual Organization website. Imagine the organization requires a database driven application that will store basic user profile and login information. Create a database and a database schema that provides details of the tables, relationships, and keys incorporating the profile details. You choose the software in which to build the schema. Include example data in the database. Create a SQL dump file of your database if it is built from one of the following database management systems (DBMSs): Microsoft® SQL Server®, Oracle®, mySQL®, or Microsoft® Access®.
Yes, I can wait 24hrs for a response.
I installed MySQL for Windows, full version from Oracle and tried to use Data Import/Restore to open the file, but I got this error message:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PK' at line 1
Not sure what to do. I think the SQL version I have might be version 126.96.36.199.msi