Employee Database Sql
Required skills: SQL
I need a SQL database completed in Express 2008. The details are as follows and it must be completed by Saturday the 25th:
Create an SQL server database for the Kudler Fine Foods Virtual Organization.
--Comment goes here
CREATE DATABASE CASEKudlerFineFoods
ON PRIMARY
(NAME = Case_KudlerDB_dat,
FILENAME = "C:POS410MyStuffCase_KudlerDB_dat.mdf",
SIZE = 10MB,
MAXSIZE = 100MB
FILEGROWTH = 10%)
--Comment goes here
LOG ON
(NAME="Case_KudlerDB_log",
FILENAME="C:POS410MyStuffCase_KudlerDB_log.ldf",
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 20%)
(Note: Table connected by key means that if you have a primary key of Employee ID in the EMPLOYEE table, and Employee ID as a foreign key in the Job Title table, indicate the join in the data dictionary.)
• Create the following two tables using the following fields:
• Note: Comment all your code. An example comment would look like the following:
--Comment goes here
CREATE TABLE [EmployeeDB].dbo.tblEmployee
(
EmpID char (6) CONSTRAINT custNoKey PRIMARY KEY Not Null,
EmpeeLName char (25) Not Null,
EmpeeFName char (20) Not Null,
• Note: Supply the SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, you will need to either utilize one of the listed fields as the table's primary key or you will need to create an additional field to use as the primary key. The primary key from the Job Title table will appear as the foreign key in the Employee table.
Table 1 Employee
• Employee ID
• Last name
• First name
• Address
• City
• State
• Telephone area code
• Telephone number
• Employer Information Report (EEO-1) classification
• Hire date
• Salary
• Gender
• Age
• Foreign key from Job Title table
Table 2 Job_title
• EEO-1 classification
• Job title
• Job description
• Exempt/non-exempt status
• Use the SQL INSERT statement to insert records from the Human Resources department in the Kudler Fine Foods Virtual Organization. Using information found in the Employee Files for the La Jolla and Encinitas stores, enter records into the Employee table for the following employees:
o Glenn Edelman
o Eric McMullen
o Raj Slentz
o Erin Broun
o Donald Carpenter
o David Esquivez
o Nancy Sharp
• Use the Job classifications and descriptions information to enter records into the Job Title table for the following titles:
o Accounting clerk
o Assistant manager
o Bagger
o Cashier
o Computer support specialist
o Director of finance and accounting
o Retail assistant bakery and pastry
o Retail assistant butchers and seafood specialists
o Stocker
• Check results by selecting all columns from both tables. Non-exempt employees at Kudler Fine Foods are paid an hours wage and must track their working hours.
• Screen Shot – take screen shots of your successful implementation of your code and submit as attachments.
• Save your SQL in a txt file in Notepad and submit as an attachment in your individual forum.
Data Dictionary (You will be submitting your updated data dictionary each week and with your final project submission)
• Note: Create a data dictionary in order to identify the contents of your database, the keys that connect the tables and the tables that are connected by the keys. Create this data dictionary in MS Excel or similar spreadsheet program or in a table in MS Word or similar word processing program.
Use the following column labels to fill the data dictionary:
• Table Name
• Column Name
• Data Type
• Data Length
• Nullable (Yes/No)
• Primary Key
• Foreign Key (if any)
• Table connected by key
• Comments
Create an SQL server database for the Kudler Fine Foods Virtual Organization.
--Comment goes here
CREATE DATABASE CASEKudlerFineFoods
ON PRIMARY
(NAME = Case_KudlerDB_dat,
FILENAME = "C:POS410MyStuffCase_KudlerDB_dat.mdf",
SIZE = 10MB,
MAXSIZE = 100MB
FILEGROWTH = 10%)
--Comment goes here
LOG ON
(NAME="Case_KudlerDB_log",
FILENAME="C:POS410MyStuffCase_KudlerDB_log.ldf",
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 20%)
(Note: Table connected by key means that if you have a primary key of Employee ID in the EMPLOYEE table, and Employee ID as a foreign key in the Job Title table, indicate the join in the data dictionary.)
• Create the following two tables using the following fields:
• Note: Comment all your code. An example comment would look like the following:
--Comment goes here
CREATE TABLE [EmployeeDB].dbo.tblEmployee
(
EmpID char (6) CONSTRAINT custNoKey PRIMARY KEY Not Null,
EmpeeLName char (25) Not Null,
EmpeeFName char (20) Not Null,
• Note: Supply the SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, you will need to either utilize one of the listed fields as the table's primary key or you will need to create an additional field to use as the primary key. The primary key from the Job Title table will appear as the foreign key in the Employee table.
Table 1 Employee
• Employee ID
• Last name
• First name
• Address
• City
• State
• Telephone area code
• Telephone number
• Employer Information Report (EEO-1) classification
• Hire date
• Salary
• Gender
• Age
• Foreign key from Job Title table
Table 2 Job_title
• EEO-1 classification
• Job title
• Job description
• Exempt/non-exempt status
• Use the SQL INSERT statement to insert records from the Human Resources department in the Kudler Fine Foods Virtual Organization. Using information found in the Employee Files for the La Jolla and Encinitas stores, enter records into the Employee table for the following employees:
o Glenn Edelman
o Eric McMullen
o Raj Slentz
o Erin Broun
o Donald Carpenter
o David Esquivez
o Nancy Sharp
• Use the Job classifications and descriptions information to enter records into the Job Title table for the following titles:
o Accounting clerk
o Assistant manager
o Bagger
o Cashier
o Computer support specialist
o Director of finance and accounting
o Retail assistant bakery and pastry
o Retail assistant butchers and seafood specialists
o Stocker
• Check results by selecting all columns from both tables. Non-exempt employees at Kudler Fine Foods are paid an hours wage and must track their working hours.
• Screen Shot – take screen shots of your successful implementation of your code and submit as attachments.
• Save your SQL in a txt file in Notepad and submit as an attachment in your individual forum.
Data Dictionary (You will be submitting your updated data dictionary each week and with your final project submission)
• Note: Create a data dictionary in order to identify the contents of your database, the keys that connect the tables and the tables that are connected by the keys. Create this data dictionary in MS Excel or similar spreadsheet program or in a table in MS Word or similar word processing program.
Use the following column labels to fill the data dictionary:
• Table Name
• Column Name
• Data Type
• Data Length
• Nullable (Yes/No)
• Primary Key
• Foreign Key (if any)
• Table connected by key
• Comments
Posted In:SQL |
Related projects:
Database Sql Queries Server Overload In Joomla 2
re is one sql request that is too long and causes server overload
i know what it is and dont have time
need someone to fix it right away
here is a link with the debug system on so you can check the queries
Additional Info (Added 1/24/2011 at 7:10 EST)...System Message: This is a reposting of project Database Sql Queries Server Overload in joomla (1295542201).
i know what it is and dont have time
need someone to fix it right away
here is a link with the debug system on so you can check the queries
Additional Info (Added 1/24/2011 at 7:10 EST)...System Message: This is a reposting of project Database Sql Queries Server Overload in joomla (1295542201).
Employee Database Sql
Wage
BETWEEN 9.00 and 13.00
--3.4 Joins two tables and uses hire_date to restrict data
SELECT *
FROM Employee
JOIN Job_title
ON Employee.Job_title=Job_title.Job_title
WHERE Hire_date
BETWEEN '1-1-1999' AND '12-31-2009'
--3.5 Sorts data by telephone area code
SELECT *
FROM Employee
JOIN Job_Title
ON Employee.Job_Title = Job_Title.Job_Title
WHERE Telephone_Area_Code
LIKE '619'
BETWEEN 9.00 and 13.00
--3.4 Joins two tables and uses hire_date to restrict data
SELECT *
FROM Employee
JOIN Job_title
ON Employee.Job_title=Job_title.Job_title
WHERE Hire_date
BETWEEN '1-1-1999' AND '12-31-2009'
--3.5 Sorts data by telephone area code
SELECT *
FROM Employee
JOIN Job_Title
ON Employee.Job_Title = Job_Title.Job_Title
WHERE Telephone_Area_Code
LIKE '619'
database - sql
we want someone to download our database - sql and give us the file csv and .sql
max 30 usd
start now
max 30 usd
start now
Employee Database
I need to create an employee database for the company with more than 500 employees. It should contain 3 blocks: personal info, experience with company info, training records. Of course, all kinds of reports, ability to upload an image to each employee. User guide is needed as well. Thank you and i'll provide more details during selection process.
Java Employee Database Management
Create a Complex system to manage my employee database. Communication should be available at all times. More information will be provided to serious bidders.
Automobile Automated Inventory Entry Via Sql Database
>
http://midtown-ford.dealerconnection.com/?lang=en
If possible the script should be able to pick out certain models and years of cars to be posted to the http://www.xautodealer.com/demos/template3/ online auto catalogue
Please give a total estimate of your final cost
thank you
If possible the script should be able to pick out certain models and years of cars to be posted to the http://www.xautodealer.com/demos/template3/ online auto catalogue
Please give a total estimate of your final cost
thank you
Basic Online Sql Student Database
be able to access information about his or her own students (not those of other partners.) Admin can access all records.
Important:
* Only serious tenders will be considered
* Tenders MUST provide examples of similar work done previously
* Daily updates and fast responses to our emails are essential
We regret that tenders who do not provide examples cannot be considered and that only shortlisted tenders will receive replies to messages sent on Scriptlance.
Important:
* Only serious tenders will be considered
* Tenders MUST provide examples of similar work done previously
* Daily updates and fast responses to our emails are essential
We regret that tenders who do not provide examples cannot be considered and that only shortlisted tenders will receive replies to messages sent on Scriptlance.
Sql Database With Web Interface
I need a simple database built (sql) and have a web form to enter items into the database. No reports or anything required, just need a simple way for a person to enter the data.
Each record will contain 5 items.
For now - the entire purpose of this is just to store the data.
Each record will contain 5 items.
For now - the entire purpose of this is just to store the data.
Database Sql Queries Server Overload In Joomla
hi
i have a website with a big database using a joomla component called jreviews
there is one sql request that is too long and causes server overload
i know what it is and dont have time
need someone to fix it right away
here is a link with the debug system on so you can check the queries
i have a website with a big database using a joomla component called jreviews
there is one sql request that is too long and causes server overload
i know what it is and dont have time
need someone to fix it right away
here is a link with the debug system on so you can check the queries
Convert / Migrate Ms Sql Database To Mysql
We have a 40Mb SQL database .bak file. We need it converted and migrated into a MySQL Database. We can provide access to the target database and would like to have someone simply recreate this database in MySQL from this .bak file with all the data. About 500 entries, not sure how many columns, tables, etc. but we can provide the .bak file if you need to look at this first.
Cakephp Penny Install And Sql Database
I have cake php penny auction with SQL database that I need to install for a clone swoopo site. I have the full instructions on what needs to be done along with scripts and SQL Files.
Additional Info (Added 9/8/2010 at 17:37 EST)...FYI:Ebay scripters do it for under $ 50.
Additional Info (Added 9/8/2010 at 17:37 EST)...FYI:Ebay scripters do it for under $ 50.
Iphone And Bb Product Search App Using Sql Or Excel Database
le.textDecoration='underline'" onmouseout="this.style.textDecoration='none'">http://www.qualmax.com/product_search_test.php)
It would also include introduction page about the company and direct link to pop-up call and pop-up email. The apps should look highquality and userfriendly for the company image.
Please inform which apps you have developed in the past so I could get a basic idea of your experience.
Thank you.
Paul
It would also include introduction page about the company and direct link to pop-up call and pop-up email. The apps should look highquality and userfriendly for the company image.
Please inform which apps you have developed in the past so I could get a basic idea of your experience.
Thank you.
Paul
Sql Database
I need a SQL database built.
I need to have a web interface to be able to do queries of the data.
the database will have about 15 fields .
I need to have a web interface to be able to do queries of the data.
the database will have about 15 fields .
Mysql Database Adjustment
based on the Wordpress/Premiumpress platform. In his store however, he has a scanner for processing his sales for instore clients. He requires that the database of the web site (mysql) marries up with the scanner database (sql format unknown for now) in one aspect, only and that the stock levels talley. this way if a purchase is made from the store, it will inform the database of the web site so as not to process out of stock goods. Also Web site configuration to recognise the new set up
Sql Oracle Plus Final
and last name as a single column and provide an alias for the column.
(Points : 15)
4. (TCO 7) Write a query that will list the customer number, last name, and first name for every customer represented by sales rep 03 or sales rep 12.
(Points : 15)
5. (TCO 7) Write a query that will list the customer first and last name and the sales rep commission rate using JOIN ON.
(Points : 15)
(Points : 15)
4. (TCO 7) Write a query that will list the customer number, last name, and first name for every customer represented by sales rep 03 or sales rep 12.
(Points : 15)
5. (TCO 7) Write a query that will list the customer first and last name and the sales rep commission rate using JOIN ON.
(Points : 15)
Sql Oracle Plus Final
e column and provide an alias for the column.
4. (TCO 7) Using the BETWEEN operator, write a query that will list all details about all orders that were placed during the period of September 3rd thru September 5th of 1998.
5. (TCO 7) Write a query that will list the customer first and last name and the sales rep commission rate using JOIN ON.
(I will attach files with all of the chart questions because they won't copy right)
4. (TCO 7) Using the BETWEEN operator, write a query that will list all details about all orders that were placed during the period of September 3rd thru September 5th of 1998.
5. (TCO 7) Write a query that will list the customer first and last name and the sales rep commission rate using JOIN ON.
(I will attach files with all of the chart questions because they won't copy right)
Remote Database
Need an expert who is very familiar with microsoft sql server 2008 R2
to do the following.
Show me how to restore database on remote server successfully.
Configure the remote server database so that C# software
can directly make changes to the database. Let me know the steps taken.
Create a simple C# software to demonstrate read
and write data to the remote database and give me the codes.
to do the following.
Show me how to restore database on remote server successfully.
Configure the remote server database so that C# software
can directly make changes to the database. Let me know the steps taken.
Create a simple C# software to demonstrate read
and write data to the remote database and give me the codes.
ERD&Use case, ORACLE Database/ SQL queries + Report Writing
cessful bid) :
Management Report writing + few descriptions ( about 1600 words)
Use Case Modelling & ERD Development using UML (full specifications for each Use Cases[2 or 3] and brief report/presentation of all)
Oracle Database in ORACLE 11g & SQL Queries creation
+commentaries on what was done
The whole project and some instructions will be sent after a successful bid
It should take about 10-15 hours
Management Report writing + few descriptions ( about 1600 words)
Use Case Modelling & ERD Development using UML (full specifications for each Use Cases[2 or 3] and brief report/presentation of all)
Oracle Database in ORACLE 11g & SQL Queries creation
+commentaries on what was done
The whole project and some instructions will be sent after a successful bid
It should take about 10-15 hours
Data Import / Normalize For Song Database
Existing database with 30,000 songs. I need to append another 5000 songs in the same structure into the database.
SQL database. records contain 2 fields.
SQL database. records contain 2 fields.
Database Normalization 2
Two Assignments on Normalization Database Design Using SQL and another using Denormalization and Read only databases all the details are in the attached documents.
Additional Info (Added 12/6/2010 at 6:16 EST)...System Message: This is a reposting of project Database Normalization (1291138310).
Additional Info (Added 12/6/2010 at 6:16 EST)...System Message: This is a reposting of project Database Normalization (1291138310).
