MySQL Homework Help - Answers

Developers are often tasked with creating interfaces that make it easy for non-developers to view and interact with information stored in databases. Often these interfaces are known as **C**ontent **M**anagement **S**ystems. In this homework assignment, your challenge is to architect and build a solution for managing a company's employees using node, inquirer, and MySQL.

## Instructions

Design the following database schema containing three tables:


* **department**:

 * **id** - INT PRIMARY KEY

 * **name** - VARCHAR(30) to hold department name

* **role**:

 * **id** - INT PRIMARY KEY

 * **title** - VARCHAR(30) to hold role title

 * **salary** - DECIMAL to hold role salary

 * **department_id** - INT to hold reference to department role belongs to

* **employee**:

 * **id** - INT PRIMARY KEY

 * **first_name** - VARCHAR(30) to hold employee first name

 * **last_name** - VARCHAR(30) to hold employee last ...

Now that we have a relatively good understanding about creating tables. We will need to go a step farther and start using them. This assignment will consist of a few requirements –

- You will be creating a Registration table and a Course Instructor table

✓ Registration will be used to register student into a section.

✓ Course Instructor will be used to register faculty with a section.

✓ Both tables will require Primary Keys so that a student cannot register for same section more than once and same for faculty.

✓ Both tables will need to maintain referential integrity. You need to be an instructor in order to register to teach a section and a section needs to be valid, etc. This should be done through Foreign Keys. ✓ You should create the parent keys before trying to create the child records.

- You will need to add 5 rows of data to each table, which is 35 total records across your schema.

- For the records in each table. You will need to use sequences. This will enable you to create a surrogate key for all your records.

CREATE SEQUENCE student_id_seq START WITH 1000 INCREMENT BY ...

A.GUI based application. b. Implementation of Object-oriented concept c. Data of your application should be persist in database. d. Unit Testing of your application e. Simple algorithm for searching and sorting

MIS 4300 Fundamental Database exam. The exam will be over Chapter 10 (Transaction Management and Concurrency Control) and Chapter 11 (Database Performace Tuning and Query Optimization). 25 MCQs- 25 minutes duration. 

This assignment contains THREE (3) parts: design, data and queries, and an assessment. All parts of the assessment relate to the Ace Property Rentals scenario 

Hello, i need help please, Hi i need a screen shot of the coding, file placement, and outcome of the following

Scenario:

Imagine you have been contracted to develop a system for processing data for an organization that sells household items and electronics. Just like any organization, there are departments such as IT, customer service, marketing, sales, payroll, accounts payable, and some sort of operations. Within each department, employees will have specific jobs (supervisor, administrative assistant, and janitor). All employees are paid a salary and benefits. The only exception is the sales department where employees are paid a commission as well. To calculate commission, this is the formula:

Employee’s commission rate = product commission amount X quantity sold.

Instructions:

For this assignment, you must create the entities and attributes via MySQL Workbench or SQL queries to model the above business case. Open MySQL Workbench and perform the following tasks:

1. Create a schema with the appropriate entities and attributes to fit the scenario above.
2. In your new database, add sufficient data for each of the entities and attributes – at least five departments with at least ten employees in each.
3. Expor...

.

Instructions are in PDF format. When you finish it, please make it as zip file so I can download and turn them in.

You should choose some part or all of your project model and implement them with MySQL, php, or other tools. All source code needs to be uploaded to BlackBoard with the instructional documents to verify it.

I have what I have figured out so far under each question but I know my solutions after question 2 is incorrect. I need help completing the rest.

Describe your organization's data structure.

Create a comparison chart or table that lists and compares the features and functions of data within your organization. These functions should be related to the Enterprise function. For example, email archives may be compressed for space, but have key discussion threads. The customer information database needs normalization if multiple persons enter data on clients.

Create a data structure diagram for internal data at your organization and identify external support data to the organizations suppliers.

Include two process diagrams, which show Local Area Network (LAN) location, network mapping location, and storage size.

Create a reference log that identifies the resources and/or references you used in creating the diagram.

Complete the diagrams using Microsoft® Visio®.