Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 11-24-2012, 11:43 AM   #1
Bycrim
Newly Registered User
 
Join Date: Nov 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Bycrim is on a distinguished road
Trying to model this case study into an ERD

Dear All,

I am bit confused on how to structure this scenerio as some of the entities have same attributes and some having two unique attributes in a table. Please, how can this be sorted out? Below is the case study. Thank you.

A DVD Rental Company has several branches, one in Manchester, one in London and one in Birmingham . The data held on each branch is the branch address made up of street, city, county, postcode and the telephone number. Each branch is given a branch number, which is unique throughout the company .

Each branch is allocated staff, which includes 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 DVDs. The data held on a DVD is the catalogue number, DVD number, title, category, daily rental, cost, status and the names of the main actors and director. The catalogue number uniquely identifies the DVD. In some cases, however, there are several copies of each DVD at a branch, and the individual copies are identified using the DVD number. A DVD is given a category such as Action, Children, Drama, Sci-Fi or Horror. The status indicates whether a specific copy of a DVD is available for rent.

Before borrowing a DVD from the company, a customer must first register as a member of a local 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 DVDs, up to a maximum of ten at any one time . The data held on each DVD rented is the rental number, the full name and number of the member, the DVD number, title and daily rental, and the dates the DVD is rented out and returned. The DVD number is unique throughout the company

Bycrim is offline   Reply With Quote
Old 11-24-2012, 06:01 PM   #2
plog
Banishment Pending
 
Join Date: May 2011
Posts: 9,403
Thanks: 11
Thanked 2,282 Times in 2,234 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Trying to model this case study into an ERD

We don't mind helping with homework, but we do mind doing homework. So, what do you have so far and where are you stuck?
plog is offline   Reply With Quote
Old 11-24-2012, 11:54 PM   #3
Bycrim
Newly Registered User
 
Join Date: Nov 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Bycrim is on a distinguished road
Re: Trying to model this case study into an ERD

Hi Plog,

I was actually given a ready-made database to improve by adding the database of the scenario provided.

Please, find attached a screen shot of what I've got so far.

Thanks.
Attached Images
File Type: png screenshot.PNG (94.0 KB, 1109 views)

Bycrim is offline   Reply With Quote
Old 11-26-2012, 06:49 AM   #4
plog
Banishment Pending
 
Join Date: May 2011
Posts: 9,403
Thanks: 11
Thanked 2,282 Times in 2,234 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Trying to model this case study into an ERD

That's a huge mess with more tables than you initially described. Looks like you have some website specific tables in there as well, which is complicating things.

Can you ask a specific question? I don't know exactly how to help.
plog is offline   Reply With Quote
Old 04-22-2013, 08:10 PM   #5
proview
Newly Registered User
 
Join Date: Apr 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
proview is on a distinguished road
Re: Trying to model this case study into an ERD

Hi Plog, i'm refreshing my (basic) ERD skills and have given a stab at the entities, relations and constraints. Just want to get your take on if i'm in the right direction.
Attached Files
File Type: pdf 2014_001.pdf (18.4 KB, 221 views)


Last edited by proview; 04-22-2013 at 08:11 PM. Reason: don't want to put names
proview is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL vs DAO or ADO Object Model jerryczarnowski Queries 15 06-12-2012 06:01 AM
Autogenerating study ID number UCLA Lorna Forms 1 09-13-2008 11:21 AM
how to create study flashcards ijtrades Forms 0 11-09-2007 02:12 AM
[SOLVED] Xcel obj model mission2java_78 General 1 01-29-2003 02:37 PM




All times are GMT -8. The time now is 12:20 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World