Order Now

Database sql lab | Computer Science homework help

Essay Help

load-project.sql

LOAD DATA LOCAL INFILE “project.dat”
INTO TABLE project
FIELDS ENCLOSED BY “”” TERMINATED BY “,”
;

department.sql

DROP TABLE department;
CREATE TABLE department (
dname varchar(25) not null,
dnumber integer(4),
mgrssn char(9) not null,
mgrstartdate date,
primary key (dnumber),
key (dname)
);

worksOn.sql

DROP TABLE works_on;
CREATE TABLE works_on (
essn char(9),
pno integer(4),
hours decimal(4,1),
primary key (essn,pno),
foreign key (essn) references employee(ssn),
foreign key (pno) references project(pnumber)
);

project.sql

DROP TABLE project;
CREATE TABLE project (
pname varchar(25) not null,
pnumber integer(4),
plocation varchar(15),
dnum integer(4) not null,
primary key (pnumber),
unique (pname),
foreign key (dnum) references department(dnumber)
);

dept_locations.sql

DROP TABLE dept_locations;
CREATE TABLE dept_locations (
dnumber integer(4),
dlocation varchar(15),
primary key (dnumber,dlocation),
foreign key (dnumber) references department(dnumber)
);

source.sql

source department.sql
source employee.sql
source project.sql
source dept_locations.sql
source dependent.sql
source worksOn.sql
source load-department.sql
source load-employee.sql
source load-project.sql
source load-dloc.sql
source load-dependent.sql
source load-worksOn.sql

load-worksOn.sql

LOAD DATA LOCAL INFILE “worksOn.dat”
INTO TABLE works_on
FIELDS ENCLOSED BY “”” TERMINATED BY “,”
;

README.html

There are three files for each table in this directory. For example for the
DEPARTMENT table the three files are:

<ol>
<li> department.sql: contains the SQL Create Table statement to create the table.
<li> department.dat: contains data for the table to be loaded using the MySQL load command.
<li> load-department.sql: contains the LOAD command to load data into the table.
</ol>

<P>
The file, source.sql, contains MySQL “source” commands to execute the “create table” and
“load” commands for each table.

<P>
After signing in to MySQL and changing to “company” database, simply run the following
command to create and populate the tables:

<P>
mysql> source source.sql

load-dloc.sql

LOAD DATA LOCAL INFILE “dloc.dat”
INTO TABLE dept_locations
FIELDS ENCLOSED BY “”” TERMINATED BY “,”
;

ThislabinstructonsonhowtodesignEERdiagram_CreateDDLstatements_LoadDDLandpublishqueries.docx

This lab focuses on the design, build, and use of a relational database. Use MySQL and complete the following:
This is not an essay.

Complete an EER diagram of the company database described in chapter 4. You may use Visio, PowerPoint, MySQL Workbench, or gliffy.com Review Chapter 4 of the
Fundamentals of Database Systems 7E book on how to create an EER diagram.

1.
Create a database based on your design and provide the Create Table Statements. Write the Create table statements (even if you create the tables in MS Access, you need to provide the Create Table statements).
Keep in mind keys and referential integrity requirements

2. Use the Company SQL data files provided and load the database into MySQL and provide the output for following querries. Please review
Database Example file and the attach SQL and DAT files for reference.

· Prepare the following queries:

1.
Select * from each table

2.
Complete a query with at least 2 joins

3.
Complete a query with 2 joins and the use of an aggregate function like average or sum

4.
Complete a query using an outer join

3. You should submit your
EER diagram,
DDL statements,
Load DDL, and
queries in a single document.

load-dependent.sql

LOAD DATA LOCAL INFILE “dependent.dat”
INTO TABLE dependent
FIELDS ENCLOSED BY “”” TERMINATED BY “,”
;

load-department.sql

LOAD DATA LOCAL INFILE “department.dat”
INTO TABLE department
FIELDS ENCLOSED BY “”” TERMINATED BY “,”
;

load-employee.sql

LOAD DATA LOCAL INFILE “employee.dat”
INTO TABLE employee
FIELDS ENCLOSED BY “”” TERMINATED BY “,”
;

dependent.sql

DROP TABLE dependent;
CREATE TABLE dependent (
essn char(9),
dependent_name varchar(15),
sex char,
bdate date,
relationship varchar(8),
primary key (essn,dependent_name),
foreign key (essn) references employee(ssn)
);

employee.sql

DROP TABLE employee;
CREATE TABLE employee (
fname varchar(15) not null,
minit varchar(1),
lname varchar(15) not null,
ssn char(9),
bdate date,
address varchar(50),
sex char,
salary decimal(10,2),
superssn char(9),
dno integer(4),
primary key (ssn),
foreign key (superssn) references employee(ssn),
foreign key (dno) references department(dnumber)
);

FundamentalsofDatabaseSystems7E.pdf

Continue to order Get a quote
Place your order
(550 words)

Approximate price: $22

July 1, 2023
    

Student Instructions

For each assignment, you will complete the following steps:

  1. Click on Learning Materials to Access the M.U.S.E.
  2. Use the M.U.S.E. link to complete the lab for this Unit.
  3. Track your results in the lab worksheet that is provided.
  4. Complete a lab report using the scientific method.
  5. Submit your completed lab worksheet to the assignment box.

Using the Laws of Inheritance

Gregor Mendel's studies laid the foundation for modern genetics. In a series of elegant experiments, Mendel was able to deduce the most fundamental laws of single-gene and multiple-gene inheritance without having the scientific data on chromosomes, their structure, or meiotic segregation. In this lab, you will learn about and apply examples for 3 different patterns of human inheritance of traits.

In this lab, you will view information and complete activities to answer the following questions about genes and inheritance:

  • What is a Punnett Square? How can it be used to analyze possible genetic outcomes for offspring?
  • What is dominant/recessive inheritance?
  • What is X-linked inheritance?
  • What is codominant inheritance of genes?

Using the M.U.S.E. link, review the background information and animation to complete your report. Use the lab 3 worksheet for assignment instructions and data collection.

This assignment will also be assessed using additional criteria provided here.

Please submit your completed assignment in your assignment box.

 

Grading Category Category Criteria Percentage and Points Possible
Purpose of Assignment and Content Development Use of appropriate, relevant, and compelling content that expresses topic, main idea, and purpose.

45% (90 of 200 points)
Organization, Grammar, and Presentation Organized and complete lab report/worksheet with all relevant information as indicated and outlined on the worksheet.  Language clearly and effectively communicates ideas and content relevant to the assignment.

30% (60 of 200 points)
Critical Thinking Demonstrates ability to analyze assumptions, evaluate evidence, complexities of issues, and alternatives.

20% (40 of 200 points)
Information Literacy and Research Demonstrates good selection and use of high quality, credible, and relevant sources to develop ideas that are appropriate to the assignment.  Includes correct in-text citations.

5%  (10 of 200 points)

For assistance with your assignment, please use your text, Web resources, and all course materials.

default image
July 1, 2023
    

Student Instructions

For each assignment, you will complete the following steps:

  1. Click on Learning Materials to Access the M.U.S.E.
  2. Use the M.U.S.E. link to complete the lab for this Unit.
  3. Track your results in the lab worksheet that is provided.
  4. Complete a lab report using the scientific method.
  5. Submit your completed lab worksheet to the assignment box.

Using the Laws of Inheritance

Gregor Mendel's studies laid the foundation for modern genetics. In a series of elegant experiments, Mendel was able to deduce the most fundamental laws of single-gene and multiple-gene inheritance without having the scientific data on chromosomes, their structure, or meiotic segregation. In this lab, you will learn about and apply examples for 3 different patterns of human inheritance of traits.

In this lab, you will view information and complete activities to answer the following questions about genes and inheritance:

  • What is a Punnett Square? How can it be used to analyze possible genetic outcomes for offspring?
  • What is dominant/recessive inheritance?
  • What is X-linked inheritance?
  • What is codominant inheritance of genes?

Using the M.U.S.E. link, review the background information and animation to complete your report. Use the lab 3 worksheet for assignment instructions and data collection.

This assignment will also be assessed using additional criteria provided here.

Please submit your completed assignment in your assignment box.

 

Grading Category Category Criteria Percentage and Points Possible
Purpose of Assignment and Content Development Use of appropriate, relevant, and compelling content that expresses topic, main idea, and purpose.

45% (90 of 200 points)
Organization, Grammar, and Presentation Organized and complete lab report/worksheet with all relevant information as indicated and outlined on the worksheet.  Language clearly and effectively communicates ideas and content relevant to the assignment.

30% (60 of 200 points)
Critical Thinking Demonstrates ability to analyze assumptions, evaluate evidence, complexities of issues, and alternatives.

20% (40 of 200 points)
Information Literacy and Research Demonstrates good selection and use of high quality, credible, and relevant sources to develop ideas that are appropriate to the assignment.  Includes correct in-text citations.

5%  (10 of 200 points)

For assistance with your assignment, please use your text, Web resources, and all course materials.

default image
July 1, 2023
    

Student Instructions

For each assignment, you will complete the following steps:

  1. Click on Learning Materials to Access the M.U.S.E.
  2. Use the M.U.S.E. link to complete the lab for this Unit.
  3. Track your results in the lab worksheet that is provided.
  4. Complete a lab report using the scientific method.
  5. Submit your completed lab worksheet to the assignment box.

Using the Laws of Inheritance

Gregor Mendel's studies laid the foundation for modern genetics. In a series of elegant experiments, Mendel was able to deduce the most fundamental laws of single-gene and multiple-gene inheritance without having the scientific data on chromosomes, their structure, or meiotic segregation. In this lab, you will learn about and apply examples for 3 different patterns of human inheritance of traits.

In this lab, you will view information and complete activities to answer the following questions about genes and inheritance:

  • What is a Punnett Square? How can it be used to analyze possible genetic outcomes for offspring?
  • What is dominant/recessive inheritance?
  • What is X-linked inheritance?
  • What is codominant inheritance of genes?

Using the M.U.S.E. link, review the background information and animation to complete your report. Use the lab 3 worksheet for assignment instructions and data collection.

This assignment will also be assessed using additional criteria provided here.

Please submit your completed assignment in your assignment box.

 

Grading Category Category Criteria Percentage and Points Possible
Purpose of Assignment and Content Development Use of appropriate, relevant, and compelling content that expresses topic, main idea, and purpose.

45% (90 of 200 points)
Organization, Grammar, and Presentation Organized and complete lab report/worksheet with all relevant information as indicated and outlined on the worksheet.  Language clearly and effectively communicates ideas and content relevant to the assignment.

30% (60 of 200 points)
Critical Thinking Demonstrates ability to analyze assumptions, evaluate evidence, complexities of issues, and alternatives.

20% (40 of 200 points)
Information Literacy and Research Demonstrates good selection and use of high quality, credible, and relevant sources to develop ideas that are appropriate to the assignment.  Includes correct in-text citations.

5%  (10 of 200 points)

For assistance with your assignment, please use your text, Web resources, and all course materials.

default image
Essay (any type)
August 22, 2022
    

They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.

 

default image
Customer #32567
Zoology, 8 Pages
Case study
August 22, 2022
    

Completed quickly and followed instructions given. Grammar, spelling, etc. was all good as well. Thank you so much! Will hire in the future.

default image
Customer #30093
Biology (and other Life Sciences), 6 pages
Presentation/PPT
August 22, 2022
    

The work has not been graded but I like the output that was submitted to me. Is it possible for the same prof to do the next assignment I will be submitting? If possible, I will greatly appreciate it.

default image
Customer #37612
Computer science, 8 pages
Journal article
August 22, 2022
    

My third using this writer and absolutely amazing work! Very punctual and very understanding.

default image
Customer #34820
Agriculture, 4 pages
Article
August 22, 2022
    

Outstanding job in writing my paper. I am always thrill to receive a well written paper that follows the instructions and the thorough details put into my paper. The quality of this paper is beyond awesome. Thank you so much.

default image
Customer #17907
Technology, 5 pages
Thesis/Thesis chapter
August 22, 2022
    

I absolutely love this writer! He/she always cranks out a fabulous paper and follows the assignment guidelines/instructions perfectly. Thanks again for always providing such quality work!!!

default image
Customer #32146
Economics, 9 pages
Research paper
August 22, 2022
    

It took some time to achieve the product I was looking for, but we eventually got there. I do feel like a lot of hard work was put into this, and it even exceeded the page requirement. I'm pretty pleased overall. I give my thanks.

default image
Customer #22371
Ecology, 5 pages
Lab Report
August 22, 2022
    

Outstanding work! This writer followed every instruction and my paper came back with an A! I recommend to anyone needing help! Thank you again ❤️

default image
Customer #13712
Nursing, 6 pages
Outline
August 22, 2022
    

Outstanding job in writing my paper. I am always thrill to receive a well written paper that follows the instructions and the thorough details put into my paper. The quality of this paper is beyond awesome. Thank you so much.

default image
Customer #267302
IT, Web, 6 pages
Essay (any type)
August 22, 2022
    

Made 100% on both the outline and the paper. Quick turnaround time and my writer responded within 30 min or less. Any edits my instructor needed, my writer was patient and worked diligently to accomplish the task. Would recommend my writer to anyone!

default image
Customer #14472
International Trade, 8 pages
Essay (any type)
August 5, 2021
    

You are making my life so much easier! I am a single mom that works and goes to school. You guys are helping me with my projects so I can have more free time with my son.

default image
customer #13832
Tourism, 3 pages
Annotated Bibliography
August 5, 2021
    

I was sure it can fit in a single page but the next time I will add one more page because I am impressed with your professionalism and quality. Will use many more times till I graduate.

default image
customer #12008
Management, 7 pages
Essay (any type)
August 5, 2021
    

Simple registration and quality services. I just ordered one paper, and it was good enough to pass the exam. That is what I need the most. Good job.

default image
customer #16257
Communication, 4 pages
Research Proposal
August 5, 2021
    

I couldn’t finish my freaking essay, and I was very desperate. A friend of mine sent me a link, and that is how I found out about you guys. Thank you for professional tips and editing. Now, I understand how to write it properly.

default image
customer #17128
Law, 5 pages
Reflection
August 5, 2021
    

I’m so grateful to you since you managed to complete my term paper in one day! You are definitely the best company ever!

default image
customer #16528
Public Relations, 7 pages
Essay (any type)
August 5, 2021
    

I am sure on your ability to provide any type of paper I will order. I wish I could develop that skill your writers have to be able to have a flow of ideas and excellent sequencing of thoughts in writing.

default image
customer #19552
Medicine, 5 pages
Coursework
August 5, 2021
    

I ordered a thesis paper and was satisfied. All the guys were polite and highly professional, even when I wrote to them several times per day. Thanks for your passion!

default image
customer #20376
Nursing, 6 pages
Discussion Essay
August 5, 2021
    

I turned to the service twice, and my papers always were beyond the expectations. To tell the truth, I was ready to find some grammar errors or something like that. However, everything was neat and tidy.

default image
customer #18529
Marketing, 1 page
August 5, 2021

My friend recommended Doctor My Essay to me. It is convenient! Now we both turn to the service periodically coz wanna save some time and use it more effectively. I know that while I’m developing my startup, an expert is working on paper. Time management in work!

default image
Research Paper
August 5, 2021
    

I write all paper works by myself but have some problems with literacy. Actually, I have enormous problems because English is not my native language. However, with proofreading from Doctor My Essay, I can relax and don’t be ashamed of mistakes.

default image
customer #12924
Business, 7 pages
Argumentative Essay
August 5, 2021
    

Your ability to write concisely is a finding. The paper has a solid argument. It’s clear that the writer understood central claim about the topic. He also presented original ideas to consider.

default image
customer #19304
Management, 3 pages
Coursework
August 5, 2021
    

That paper got the highest grade in my class and the professor thinks I’m the smartest student. Lol.

default image
customer #12387
Accounting, 6 pages
Essay (any type)
August 5, 2021
    

I was convinced that paper writing services are the fiction for naive students. But when it came to my research paper that was to be composed in 72 hours, I had no other options. I made the right choice when I ordered it from you!

default image
customer #12924
Ethics, 4 pages
Business Plan
August 5, 2021
    

I was also satisfied with the service. Usually, I write everything by myself, but this time ( I have no idea how it happens!) I missed the deadline. My writer was very responsible, wrote the essay quickly, and kept the instructions. Nice to know that such experts exist!

default image
customer #15677
Marketing, 10 pages
Annotated Bibliography
August 5, 2021
    

It is really affordable! The prices start from 9$, which is an excellent proposal on the market. Recently I worked with another service that took much more money and provided lower quality papers.

default image
customer #11234
Sociology, 9 pages
Research proposal
August 5, 2021
    

I am absolutely satisfied. I am first timer here. Revision was made quickly, and the author met my expectations. Thanks a lot. Paper is phenomenal.

default image
customer #15327
Economics, 5 pages
Essay (any type)
August 5, 2021
    

Having heard a lot of negative reviews about such services, I was a bit skeptical. However, our cooperation with Doctor My Essay was without pitfalls. I made two comments about the final work, and they re-wrote some parts very promptly. I am satisfied and will turn to them in the future.

default image
customer #17823
Human Resource Management, 2 pages
Research paper
August 5, 2021
    

It was my first experience in online ordering, and I was a bit nervous. However, this was for nothing. I’ve got a high mark!

default image
customer #12372
Public Relations, 3 pages
Dissertation
August 5, 2021
    

I understand that buying essays is a doubtful thing. You don’t put effort, don’t represent your ideas… However, I don’t perceive Doctor My Essay as a standard service. They don’t sell papers. They share high expertise!

default image
customer #12376
Journal article, 20 pages
Coursework
August 5, 2021
    

According to my previous experience, this service is really the best. They support the client and have competitive writers. I give them a perfect score!

default image
customer #19266
Political Science, 6 pages
Admission Essay
August 5, 2021
    

Nice service! It is cool that you can use the calculator on the main page and understand the price policy. For me, it is a huge plus!

default image
customer #11437
Tourism, 1 page
Discussion Essay
August 5, 2021
    

Thanks to God I found this service! If I didn’t send my research to the teacher on time, he would eat me. I tell you! However, with doctor my essay service, I met the deadline, and I am still alive.

default image
customer #12692
Philosophy, 5 pages
Report
August 5, 2021
    

Your service is excellent! Convenient and not expensive. Thanks for that!

default image
customer #10923
Psychology, 4 pages
Essay (any type)
August 5, 2021
    

If you have problems with time management, just like me, you need to cooperate with Doctor My Essay. Once you registered and made the order, you understand how easier it makes your life! Everything is online: ordering, communication… You can control the process everywhere and be sure that an expert will provide a high-level paper.

default image
customer #17823
Business, 8 pages

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more