Find Jobs
Hire Freelancers

Database Just need simple work

$10-30 USD

Stengt
Lagt ut over 5 år siden

$10-30 USD

Betalt ved levering
The RentMeAway is a company which doing the business of paintings rental. The company will find the painting owners whose would like to rent their paintings away. The company will pay the rental based on the percentage value of the painting. The company wishes to maintain data on their customers, artists and paintings. They may have several paintings by each artist in the gallery at one time. Paintings may be rented several times by different customers. The company has some data kept in Excel format as in Table 1. They want you to analyse the data and do the proper database design for them. You begin the design with normalization. Tasks: 1. Identify Primary Key. Subsequently, identify Partial Dependencies (if any) and Transitive Dependencies (if any) for Table 1. Example: Primary Key a,b,c Partial Dependencies ad,f,g Transitive Dependencies mx,y,z 2. Prepare a Dependency Diagram that is in First Normal Form (1NF) for Table 1. (Note: You need to use all attributes listed in the table. You are not allowed to add any attribute at this stage.) 3. Resolve the Partial Dependency Problem and prepare the Dependency Diagram that is in Second Normal Form (2NF) for your answer No 2. 4. Resolve the Partial Dependency Problem and prepare the Dependency Diagram that is in Third Normal Form (3NF) for your answer No 3. Please also include Foreign Keys for the linking purpose. (Note: At this stage you are allows to add and modify attributes to create a better design for your database.) 5. Prepare a Relational Schema for your answer no 4. 6. Create a relation for each entity and insert at least 5 instances for each table. Your submission should include: 1. List of Fully Functional Dependency, Partial Dependencies and Transitive Dependencies. 2. Completed 1NF Dependency Diagram. 3. Completed 2NF Dependency Diagram 4. Completed 3NF Dependency Diagram 5. Relational Schema for 3NF. 6. Tables with at least 5 instances for each table.
Prosjekt-ID: 18272801

Om prosjektet

13 forslag
Eksternt prosjekt
Aktiv 5 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
13 freelancers are bidding on average $38 USD for this job
Brukeravatar
Greetings, I am interested in doing this job. I am BS-CS graduate and knows Database programming as well, because of which I can do this task with ease. Have worked on Orcale, MS- Access and MySQL. Hopefully we will discuss further details in PM.
$60 USD om 3 dager
4,7 (12 omtaler)
4,0
4,0
Brukeravatar
I have 17 years in Database Developing, Programming, Training, and Accounting Solutions / Finance with Computer
$30 USD om 2 dager
5,0 (2 omtaler)
1,4
1,4
Brukeravatar
I am expert in database, I will do your job as your requirements. if you are interested, your can send me ignal message then we will discuss our problem. Regards Tanveer Ahmed
$35 USD om 5 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hi, I can complete your task in 1 day with the highest quality.. I have 14 years of experience in database. Lets talk the details Regards
$50 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I just finished my course in DBMS(Database management systems) in my previous semester with excellent grades. I have read and understood your project completely and am confident that I can do it.
$20 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I am an experienced Oracle Database DBA/Developer with 28 years of Experience in USA. I was rated as a Top performer for most part of my Career in USA due to my Speed, Quality and commitment to Deliver before time.
$25 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Certified as MS DBA, I am acquainted with SQl server migration. I assist in teaching a class on MS SQL which requires a wide and indepth understanding.
$20 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Certified Microsoft developer and having 5yrs of experience in database development. Have written complex SQL queries and excellent in database desings and solutions
$35 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hello Wish you a very good day I have a good background as a Web Developer along with my excellent academic education in Software Engineering. I can provide my services for this. Looking forward to hear from you. Regards
$55 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I am Database Administration and have 3.5 years experience. I can work on this project. please call me to further discuss.
$35 USD om 10 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I am Microsoft Certified Solution Associate in SQL Server with 14 years experience in SQL server training and consulting. I am currently working as a freelance sql server developer and trainer working primarily in: Database designing (normalisation etc) Database development T SQL programming Data cleansing ETL Basic Database Administration
$30 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

BANGLADESHs flagg
Bangladesh
0,0
0
Betalingsmetode bekreftet
Medlem siden feb. 11, 2018

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.