Closed

LOOKING FOR A DATABASE RELATION EXPERT ASAP

Please read the description carefully, do not bid if you don't know what is it. The budget for this job is $20 with lots of work every month. Bonus will be paid if successfully delivered in maximum 1 or 2 day. Looking to hire someone ASAP.

Requirement

a) Using appropriate examples trace the development and critically assess the advantages and disadvantages of the hierarchical, network, and relational database models. (1,000 words maximum)

b) Draw an entity relation diagram for the following scenario of a video rental company, representing the multiplicity constraints.

XYZ Ltd is a specialist video rental company (established in May 2013) and has 3 branches in London. The data held on each branch is the branch address made up of street address, city, and postcode, and the telephone number. Each branch is given a branch number, which

is unique throughout the company. Each branch is allocated 4 staff members, including a Manager. The Manager is responsible for the day-to-day running of a given branch. The data held on a member of staff is his or her name, position, and salary. Each member of staff is

given a staff number, which is unique throughout the company. Each branch has a stock of videos. The data held on a video is the catalogue number, video number, title, category, daily rental cost, and status. The catalogue number uniquely identifies each video. However, in

most cases, there are up to 3 copies of each video at a branch, and the individual copies are identified using the video number. A video is given a category such as Action, Drama, Horror, or Sci-Fi. The status indicates whether a specific copy of a video is available for rent.

Before hiring a video from the company, a customer must first register as a member of a local branch. The data held on a member is the first and last name, address, and the date that the member registered at a branch. Each member is given a member number, which is unique

throughout all branches of the company. Once registered, a member is free to rent videos, up to maximum of five at any one time. The data held on each video rented is the rental number, the full name and number of the member, the video number, title, daily rental, and the dates

the video is rented out and date returned. The rental number is unique throughout the company.

c) Populate the relations for the above scenario (include a minimum of 5 members per branch and 5 videos per category), and show the SQL statements and the results for the following

queries:

1) List the branch numbers and addresses

2) List of members names and their postcodes

3) The address of the branch at which John Smith works

4) Total number of Horror movies in branch B1

5) List the catalogue number of videos which have not been rented in June 2013

6) List the catalogue number of videos rented by James Andrews

Skills: Database Administration, MySQL, Software Architecture, SQL

See more: data held branch branch address street, database relation expert, what salary are you looking for, staff requirement, sql company london, software development salary, software development company names, software development company london, smith hire, rent an expert, models for hire london, manager looking for job, manager looking for a job, looking for software development job, looking for software development company, looking for a specialist, june is the month for, james list, it software development salary, hiring videos, hiring bonus, hire smith, for the month of june, dates for hire, data manager job description

About the Employer:
( 2 reviews ) Rawalpindi, Pakistan

Project ID: #4890363

12 freelancers are bidding on average $35 for this job

elboukharimu

I can help you please check your Inbox

$50 USD in 3 days
(13 Reviews)
4.1
riskypathak

Hey Friend I have gone through assignment details. I can create a document having difrence between databases, ER diagram and SQL queries. However 204 is less for this much work. I will do for 30$..:) Will deli More

$30 USD in 1 day
(17 Reviews)
4.1
Reza2012

Hi I am ready to do the job. please see my profile. thanks.

$55 USD in 3 days
(6 Reviews)
3.9
VjCoder

hi check your PM!

$45 USD in 3 days
(3 Reviews)
3.5
AliSafder

Hi, I can get the work done for you. Thanks, Muhammad Ali Safder

$24 USD in 3 days
(3 Reviews)
1.9
mdakteruzzaman

Expert in Database administration and management. pls check pmb

$30 USD in 2 days
(4 Reviews)
1.3
rahulagnihotri25

Dear Team, I am a Microsoft Certified Trainer, with over 7 years of experience as an SQL Expert. I have consulted over 200 clients related with different topics of SQL (DB: Mirroring, Replication, Back up/ Restore, More

$35 USD in 3 days
(1 Review)
0.0
truongbk24

please check pm for details

$20 USD in 1 day
(0 Reviews)
0.0
SamuelsonC

Can have this done in 1 day easy. Many years of experience with Data Architecture and Database design. I am good at what I do and very efficient. I can do 1 – 10th normal form easy. If you want this done right the fir More

$25 USD in 3 days
(0 Reviews)
0.0
werder

I'm a database expert

$35 USD in 2 days
(0 Reviews)
0.0
noelparicollo

Hi, I have been assigned many jobs rtelated to Well designed databases. so you should try me.

$45 USD in 2 days
(0 Reviews)
0.0
behalmunish

Hi , I have good Knowledge in DBMS

$20 USD in 4 days
(0 Reviews)
0.0