Find Jobs
Hire Freelancers

Enhanced Entity Relationship (EER) diagram, SQL Statements (DDL, DML, and Select),Power point,

$10-30 USD

Geschlossen
Veröffentlicht vor etwa 5 Jahren

$10-30 USD

Bezahlt bei Lieferung
A nonprofit organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name,j Address, City/State/Zip, and Telephone. Three types of persons are of greatest interest: employees, volunteers, and donors. Employees have only a Date Hired attribute, and volunteers have only a Skill attribute. Donors have only a relationship (named Donates) with an Item entity type. A donor must have donated one or more items, and an item may have no donors, or one or more donors. There are persons other than employees, volunteers, and donors who are of interest to the organization so that a person need not belong to any of these three groups. On the other hand, at a given time a person may belong to two or more of these groups (e.g., employee and donor). Design your own Database project for specific system above. Your project should include the following: 1. Draw an EER diagram for the above problem using this text’s EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor to captures all requirements. 2. A full DDL statements that includes all primary keys, unique keys, foreign keys, and, check constraints. 3. You should fill your tables with many rows (main transaction tables at least 100,000 records). It is allowed to use import data utilities(like excel ….etc), or writing a transcript insert statements to create random data. 4. Writing 5 complex quires to retrieve main reports you find they important in the system.(The complex queries means it should include at least one of or more of the following: aggregate function, inline queries, correlated inner query, different types of joins, set operations etc). 5. Analysis the performance of the suggested queries and apply different techniques to enhance quires like: indexing, De-normalization. 6. Re-measure performance after applying different techniques and criticize the drawbacks of each techniques and the obtained enhancement.
Projekt-ID: 18847634

Über das Projekt

14 Vorschläge
Remote Projekt
Aktiv vor 5 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
14 Freelancer bieten im Durchschnitt $47 USD für diesen Auftrag
Avatar des Nutzers
I'm a Bsc degree holder in computer science. I have worked on many papers in report writing, research.I have read and understood your requirement and I know you will never regret, thank you.
$55 USD in 1 Tag
4,8 (24 Bewertungen)
5,1
5,1
Avatar des Nutzers
Hi I'm an expert in making ER diagrams. I'm sure that I can easily do this project. We can have a about it. Thanks..
$80 USD in 1 Tag
4,9 (9 Bewertungen)
4,4
4,4
Avatar des Nutzers
helllo i read all requirement please share more detail i did 5 similar task i will provide 5 star rating work thanks
$55 USD in 1 Tag
4,9 (6 Bewertungen)
4,0
4,0
Avatar des Nutzers
Hi, I would love to assist you in making ER diagrams based on your provided requirements, then I can check with SQL queries. Please initiate the chat to discuss this further. I am full stack developer and have been developing websites and apps for long time, you can check my profile. Looking forward to your response. Thanks Amit
$25 USD in 1 Tag
3,6 (2 Bewertungen)
3,0
3,0
Avatar des Nutzers
Hello, I am a Software Engineer. I'm experienced in software designing. I can make database assignment done. Please take a look on my porfile for sample work.. Looking forward to work on your project. Thanks.
$60 USD in 2 Tagen
5,0 (1 Bewertung)
0,8
0,8
Avatar des Nutzers
Hi, Hope you are doing good. I have gone through the project and requirement details carefully. As 7+ experienced SQL server developer I am damn sure I can finish this project with 200 % efficiency within the specified time. I have much experience in Database design, ERD diagram and DDL, DML statements and also the advanced concepts like SP, performance tuning, etc in SQL server. I am willing to work on this project at any cost. Kindly go through my profile and have a text to discuss more. Thank you.
$30 USD in 2 Tagen
5,0 (1 Bewertung)
0,4
0,4
Avatar des Nutzers
Can deliver all requests. If you have a table with all data fields already populated, can do for 50 usd
$111 USD in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hey.... I have done this type of activity in my project. I have 4 years of experience. If you are interested, let's discu this further.
$25 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I have total of 20+ years of experience in writing sql code. Once the project is awarded, with some initial understanding, can complete this project in no time.
$55 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I'm an experienced freelancer database and report design, development and optimization with 10 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. Here is few technologies I have mastered since last 10 years and can deliver the best solutions if you get me hired. I am in Florida, US 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS
$25 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A summary of my technical skills are listed below, I have:  SQL Server 2005/2008/2012 -Querying, Create Views, Procedures, Cursor, DB creation, Backup, Restoring, Job Scheduling,Database Mail Configuration,Indexing,Performance Tuning,Query Optimization,Data Archiving.  Crystal Reports 8.5 & 9 – Create Crystal Reports, Designing, Formatting, Usage of Parameters and Formula, Creating Reports using SQL query, Charts, Dynamic Image Insertion, Crosstab Reports, Sub-reports.
$35 USD in 10 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
More than 15 years of experience in data modeling. Successful ERP modeling. Great experience in the use of OPEN technologies. Deep knowledge of the design phases of data structures, from conceptual modeling to performance adjustment.
$35 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I've been working with databases since 2010. Thank you for choosing me. Looking forward to working on your project.
$35 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von INDIA
bengaluru, India
5,0
2
Zahlungsmethode verifiziert
Mitglied seit Nov. 29, 2018

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.