Closed

need sql expert who can create databases

Using the Part 1 “SmallVille Library” narrative, design and document a logical data model using Erwin. You should also make and document any reasonable assumptions where you feel the case is vague or ambiguous or missing any data necessary to meet the requirements. However you cannot ignore or overrule the requirements that are explicitly stated. Show all cardinality, prime keys and foreign keys. Use verbs to clarify your relationships. Show only the attributes that are contained explicitly in the case. Only create a new identifier for an entity if there a no existing attributes that can be reasonably used to define a primary key

Part 2 – 100 marks

Given the attached physical and logical ERD in ProjectAssign2F16ERD undertake the following:

1. Using SQL Server create a database called Project2

2. Define all primary keys, foreign keys and data types (20 marks)

3. Populate the tables with sufficient data to adequately test all aspects of your queries. (See Note below). Failure to do so will lose you marks

4. Develop the SQL queries to satisfy the questions below – 80 marks.

No views should be employed in this assignment. While no question would require it you may use dynamic temporary tables as a technique.

--1. Show for each zoo the number of different species there are for the animals in that zoo.

--2. List the zoo name, employee name and salary of each employee that is a world’s best expert in a species. Sequence the output by employee name within zoo name.

--3. List the detail of animals that are in captivity in any zoo whose mother is currently in the Boston zoo

--4. Show for each zoo in Canada a count of captive animals. Sequence the output by highest to lowest count

--5. Show for each species a count of the species qualified employees that are in total for zoos in the USA

--6. List the details for employees in any zoo in Canada with a salary of at least 75000 or that are qualified in the Tiger species. Sequence the output by employee name

--7. List the details for all animals born in captivity in 2006 that belong to an endangered species (status = E)

--8. List the details for the zoos in China that have more than 2 animals that belong to the Tiger species

--9. List the names, gender and salaries of all male employees that are the world’s best expert for a threatened species (status = T)

--10. List the details of the zoo that has the employee with the highest salary

--11. List the details for any species for which there are animals held in any zoo in China

--12. List the details for the zoos that have animals belonging to more than 3 different species. Sequence the output alphabetically by zoo within city

--13. List details for the animals that have a mother that is resident in a zoo that is different from their child's current zoo

--14. Show the name of any country that has more than 2 zoos with elephants

--15. List the species details for the species that have a world’s best expert working in a zoo in the USA which also has captive animals of that same species. Show each species only once

--16. List the details for the employee that has the lowest salary for someone qualified in the Tiger species

--17 List the details for any endangered species for which there are more than 4 animals in Canadian zoos.

--18 List the details of any zoo that has more than 3 Tigers born in 2015

--19. Show the count of how many species qualified employees are at the Toronto zoo.

--20 List the details of mothers in Canadian zoos that have more than 2 offspring in total resident in any zoo.

Skills: Database Administration, Engineering, MySQL, Software Architecture, SQL

See more: need develop simple sip api allow create product, create paragraph sql database, create joomla sql dropdown box menu, php script create xml sql, sugarcrm create call sql, create site dreamweaver need backend system, create expert advisor mt4 trading signals, create expert advisor metatrader, security need develop web site, need develop iphone application, people create expert advisors, php create field sql table, create field sql, create expert forex metatrader, create schema sql, create gui sql database, mt4 expert sql, need develop commerce website, need develop membership database web, create dll sql calls

About the Employer:
( 121 reviews ) Calcutta, India

Project ID: #12226624

20 freelancers are bidding on average ₹403/hour for this job

hardikshah83

A proposal has not yet been provided

₹444 INR / hour
(31 Reviews)
5.3
dat2na

Greetings, I'm professional database expert with 8+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs lik More

₹277 INR / hour
(2 Reviews)
4.2
hotuanthanh

I have experiences in DB design for more than 6 years. I need in total 100 USD for this project. Please contact and discuss more.

₹2222 INR / hour
(2 Reviews)
3.2
ImBillUK

Hello, We are Gifted Solutions, a Digital Creative Agency based in the UK. We have over 15 years experience in the skills needed to complete this project. We have looked over your requirements and we are confi More

₹237 INR / hour
(4 Reviews)
2.3
₹283 INR / hour
(2 Reviews)
1.7
₹388 INR / hour
(1 Review)
1.0
ksinghrajeev

Hello There, Here are some of my work examples. Project Report Automation - [url removed, login to view] Log Report Automation - [url removed, login to view] More

₹400 INR / hour
(1 Review)
1.5
alenkopic

Hi, I'm SQL developer with years of professional work experience. I can start working immediately. Best regards, Alen

₹400 INR / hour
(1 Review)
0.3
UnixExperthere

Database expert here for MySQL, MS SQL and Oracle , i can do this job...you can trust me..please reply me

₹244 INR / hour
(0 Reviews)
0.0
srivastavadivya

Hi, About your requirement - ----------------------------- An expertise(5+ years) in PHP/MySQL programming and PHP website development. My core competencies are : - experience in Windows OS in conjunction wi More

₹277 INR / hour
(0 Reviews)
0.0
engrashedul

Hello My name is Rashedul The requirements you provided are exactly what I am using all days every day, I would even add some last technology available in the most recent releases of VS to build cross-platform appli More

₹277 INR / hour
(0 Reviews)
0.0
₹222 INR / hour
(0 Reviews)
0.0
laupiais

A proposal has not yet been provided

₹277 INR / hour
(0 Reviews)
0.0
dineshroy

Hi, I have experience working in SQL Server for more than 15 years. Have extensive experience in efficient stored procedures, functions and views. Thanks

₹400 INR / hour
(1 Review)
0.0
asopapiyush

Hi My name is Piyush Asopa, I'd love an opportunity to build database for your application. I have over two years of experience of Software development including Website designing, Application designing, Software More

₹333 INR / hour
(0 Reviews)
0.0
cleidedaconcicao

A proposal has not yet been provided

₹277 INR / hour
(0 Reviews)
0.0
alltechozit

Hi we are an aspiring IT start up or group of talented programmers trying to pitch in the industry. We all have rich industry experience and trying to build our own start up. We can deliver your project in given time More

₹277 INR / hour
(0 Reviews)
0.0
EngSaraz

A proposal has not yet been provided

₹444 INR / hour
(0 Reviews)
0.0
ab18dev

Hi, I am an industry professional working on databases since the beginning of my career. I could help you with your assignment solution requirements and willing to start working on it immediately. Kindly reply back to More

₹222 INR / hour
(0 Reviews)
0.0
NetBusinessIT

I had already done job like that. I'll send you deliverables on time and with a good quality. You can count on my commitment!

₹150 INR / hour
(0 Reviews)
0.0