Answer A Few Database & SQL Exercises

This project requires the freelancer to be available on Monday, May 2nd, 2016 from 4:30pm - 5:30pm CST. This project will only take 30 mins or less, assuming a knowledgeable freelancer. DO NOT bid if you cannot be available shortly after 4:30pm CST May 2nd, 2016. You will be answering a few database questions, that will be sent via upload, email, and/or picture messaging. This shouldn't take that long. The details of the assignment can be discussed in chat. I can provide a sample to test knowledge for you too see examples. Must know: -Microsoft Access SQL Language -Write SQL statement for query -Find functional dependencies from a table provided -Transform a simple table provided into BCNF tables -Know what DBMS stands for -Know what the function of a DBMS is -Write SQL statement involving inner join -Transform a Data model (showing cardinalities) into a database design (Tables with Primary and Foreign Keys identified) -List the functional dependencies if given a table -Identify a primary key if given a table -State whether a table relation is in BCNF -Transform a table into a set of tables that are in BCNF, and also identify the primary and foreign keys -Create a query that requires joins Above is the scope of the type of write-in questions to be answered. If you can do those above tasks easily, then this is the project for you as it shouldn't take much time as this is an intro course. Must have: Email, picture/text messaging, and/or access to Freelancer website You are required to be in contact when the approaching time schedule is nearing. Lack of prompt communication by the freelancer means they are implying a failure to adhere to directions and thus agree that you will refund any milestones awarded.