Find Jobs
Hire Freelancers

Database Systems project

$30-250 USD

Completed
Posted almost 14 years ago

$30-250 USD

Paid on delivery
System description You are required to design and implement a small database application to manage any data you are interested in. Some examples are listed below for your reference: 1, if you have a collection of CDs, you can manage the data of albums, musicians, songs, companies etc. 2, if you are interested in NBA/NFL games, you can manage the data of players, teams, coaches, matches etc. 3, you can also manage your favorite movies by storing and manipulating the data of movies, actors/actresses, directors etc. Design and Implementation Perform the conceptual database design using Entity-Relationship model. You must submit the Entity-Relationship diagram of your database. In the E-R diagram, 1, there must be at least 4 entities; 2, there must be at least 2 one-to-many/one-to-one relationships; 3, there must be at least 1 many-to-many relationship. Convert your E-R diagram to logical database model. You are to design the table structure, including all needed attributes for each table. You must submit the relational database schema, which consists of the description of all tables, constraints in your database. For each table, please specify the primary key and foreign keys. Implement your design using any DBMS. You are required to create all the tables and develop queries in the target DBMS. You must generate and load appropriate, consistent data into your database. Two options are listed below, 1, MySQL: for this option, you must submit the DDL statements you used to create the tables, to define the constraints, and the SQL statements for all the queries; 2, Microsoft Office Access: for this option, you must submit the screen snapshots of design views of all tables and queries. For each query, the equivalent SQL statement must be provided as well. You must also include the database relationships diagram, which shows all relationships between tables. For other DBMSs, the requirements are similar to option#1. The bottom line is that you have to submit materials to show how you created the tables and queries. Queries You must design and develop at least 6 queries in your database application, among them, 1, at least 2 queries are multi-table queries; 2, at least 2 queries use SQL aggregate functions; 3, at least 1 query uses subquery; 4, NULL search condition should be used at least once; 5, GROUP BY and HAVING clause should be used as least once. Project Report In your report: 1, you must describe your database application; 2, you must submit the conceptual and logical design of your database as specified in section Design and Implementation, which include the E-R diagram and relational database schema of your database. For each table: a, describe all the attributes (including attribute names, data types etc.); b, specify the primary keys and foreign keys (if exist); c, discuss which Normal Form it is in; d, provide the SQL DDL statement you used to create the table, or the screen snapshots if your used GUI; e, print out all the records in the table. 3, for each query: a, describe the query; b, provide the SQL statement for it, or if you used GUI, provide the screen snapshots and the equivalent SQL statement; c, print out the results returned by the query. If you choose to use Microsoft Office Access, please submit the database file (.mdb or .accdb) along with your report.
Project ID: 668233

About the project

14 proposals
Remote project
Active 14 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
Please check PM
$50 USD in 3 days
5.0 (2 reviews)
1.4
1.4
14 freelancers are bidding on average $138 USD for this job
User Avatar
Please see PM
$225 USD in 3 days
4.8 (115 reviews)
6.7
6.7
User Avatar
Hi I can do this professionally. Regards Al
$99 USD in 2 days
5.0 (71 reviews)
5.7
5.7
User Avatar
I can do this very well
$300 USD in 10 days
5.0 (7 reviews)
5.4
5.4
User Avatar
Respected Sir, Please see PMB fir details. Kindest Regards.
$200 USD in 5 days
4.7 (14 reviews)
4.4
4.4
User Avatar
Dear Mr./Ms., Canada based and Microsoft certified professional. Quality work. Please refer your PMB. Regards
$350 USD in 10 days
4.5 (4 reviews)
3.2
3.2
User Avatar
Hello. I am a software engineer. Have done this many times. Please view PM.
$45 USD in 1 day
5.0 (2 reviews)
2.4
2.4
User Avatar
I am interested please see the PM
$30 USD in 4 days
3.5 (1 review)
1.0
1.0
User Avatar
Hello This looks very interesting project.I have master degree in computer science. I have good concepts of entities and their relationships. I have good command over MS Access. Waiting for your response.
$30 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Pls, Check PMB.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir, We are working for similiar project for last 3 years. We are well experienced with all that. Let me know when we can go ahead? Will you available on skype for further chat about project? Thanks Pooja Sharma Alien Web Developers Pvt. Ltd.
$180 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have degree in Master in Computer Application. I have good knowledge of DBMS. Please give me chance to work with you. Thanks Vaishali
$100 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am expert in databases. Please refer to your PMB for more details. Thanks
$175 USD in 5 days
0.0 (1 review)
0.0
0.0
User Avatar
Please check your PMB. Regards.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Atoka, United States
4.9
7
Payment method verified
Member since Apr 23, 2010

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.