Find Jobs
Hire Freelancers

database sqls

$10-30 USD

Completed
Posted almost 8 years ago

$10-30 USD

Paid on delivery
For the term project, please design and implement a database for the project chosen from the list provided or proposed by yourself. The total score of the term project is 100 out of 500 points. Your work will be evaluated according to the completeness and correctness of the final submission. 1. Your final submission should include: a. Project description or proposal b. A complete E-R diagram c. A complete Schema diagram d. Sample SQL statements used to manage the database, including creating tables, inserting records, updating records, deleting records, and retrieving records with various SQL queries. Please suggest different scenarios where the following keywords may be used in SQL queries: IN, EXISTS, NOT EXISTS, NOT EXISTS with EXCEPT, ALL, SOME, UNIQUE, UNION, EXCEPT, INTERSECT, NATURAL JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN and etc. For each keyword in the preceding list, create at least one query. 2. Create the database in SQL Fiddle or another database system you prefer. Run all the SQL statements you created and show the execution results in the final submission. You can do screenshot of your execution which can be added into the same file of your submission. Caveats: 1. You are free to propose your own project, but make sure the project your propose is not too complex to serve as a term project in this course. 2. Your submission should only contain one file in pdf or Word. 3. You are free to discuss the project with your friends, but don’t submit the same work. No plagiarism is tolerated. Duplication detection will be applied to all submissions. only 1 topic is needed to be done for the below given files
Project ID: 10367490

About the project

16 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.
$32 USD in 1 day
4.2 (18 reviews)
4.0
4.0
16 freelancers are bidding on average $68 USD for this job
User Avatar
Hi, Nice to meet you. My name is Manh from Vietnam. After check your project details, i feel that your project is quite suitable with my skills. I am very confident that I can complete your project with best quality. Please contact me, we can chat/discuss further on your project. Thank you so much Manh
$50 USD in 1 day
5.0 (14 reviews)
4.6
4.6
User Avatar
hi, i am expert in SQL, DB Modeling, Oracle Certified Professional, have done similar tasks in past. Can provide you a good work completing all requirements.
$29 USD in 2 days
4.7 (11 reviews)
3.7
3.7
User Avatar
I have 5 + years of experience in MSBI Technology (SQl Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Worked on various types of ER diagrams ,Data flow Diagrams, Relational Models Etc. Expert in creating Sql queries ,Dynamic T-sql,functions,triggers,indexes,Procedures,cte,temp tables and sub queries . Expert in creating SSIS package, configuration, Deployment and Scheduling and extracting the data from different sources like SharePoint lists, excel files, csv files, Data feed store, MySQL database, sql databases etc. Expert in creating different ssrs reports like drill through, drill down, parameterized, table, matrix,Chart,Line,Stacked columns, Map ,Document type etc. SSRS reports integration with SharePoint and windows applications. Fetching the data from multidimensional cube, tabular cubes with the help of MDX queries and creating SSRS reports. Expert in handling the huge databases (in TB) and performance optimization of the legacy codes.
$90 USD in 2 days
4.3 (12 reviews)
3.7
3.7
User Avatar
Hi, I have the DVD rental Project with documentation,queries, ER,EER and 3NF diagram , i can share with you the document. Contact me and I will share it with you . I can make any changes also if you required.
$30 USD in 1 day
4.9 (8 reviews)
3.1
3.1
User Avatar
I'm CS Graduate. I'have quite great skills in database. I have studied detailed courses of Databases, Data WareHoursing, Data Mining and Advanced Databases. You can find me very helpful resource for your project. I have done lots of projects in database I'm currently working in Industry as Database Developer. I have very deep knowledge of advanced concepts also. You can accept my Bid So, that we can discuss it and start soon. I can complete very fast more than your expectation Thanks and Regards
$100 USD in 1 day
5.0 (7 reviews)
2.8
2.8
User Avatar
I have around 8 years of experience in Java/SQL?Oracle I can help you in you project. You can expect some quality work on time from me.I have done most of my project in Oracle/Mysql/Sql/JavaT etc. I am looking forward to work with you. We can discuss about time and money later on
$30 USD in 1 day
4.0 (4 reviews)
2.7
2.7
User Avatar
I have 3 years experience of working with databases recently done a Dataware house project and its also a part of my fyp work so i consider myself the strongest candidate for this task can send you sample work if you will ask Thank You
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager! With a proven track record of successful achievements, I am pleased to present my application and CV for your consideration as a Web Developer. Having several years experience in the industry, and a strong educational background featuring a degree in Computer Science, I strongly believe I can make a significant contribution to First Media Web Developers. My web developing expertise includes: • Designing, building and maintaining eCommerce websites. • Strong database knowledge specifically MySQL and querying database. • Extensive knowledge of PHP, Wordpress , Joomla, Codeigniter and Laravel. • I am skilled in PHP, jQuery, AJAX, HTML5, CSS3,Bootstrap and media queries for responsiveness as well. • Additionally, advanced knowledge of back-end web technologies such as (R)DBMS , OOP , Data Structures and Algorithms • Broad experience in managing a team as well as training others in web technologies. • Adobe Photoshop I possess excellent communication skills and can liaise effectively with both clients and work colleagues. Other strong points include an ability to work as part of a team or individually, multi-task, prioritize and work to deadlines under pressure. Therefore in view of all of the above I would be highly gratified if you consider me for this important position. I am available to come in for an interview at any time, and would appreciate the opportunity to meet with you and your staff. I hope that I am granted an opportunity to talk and perhaps
$25 USD in 1 day
5.0 (2 reviews)
0.0
0.0
User Avatar
3 years of experience in database development with extensive knowledge of database designing, E-R diagram, writing complex queries, stored procedure, cursors, triggers etc.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
kansas, United States
5.0
1
Payment method verified
Member since Apr 29, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.