Käynnissä

Database design (microsoft access)

You are required to design and implement a relational database for NewMedia to store

information about writers, magazines, etc, using Microsoft Access. The detailed data

requirements are given below. You may make some assumptions about data types of attributes if

deemed appropriate. You need to enter some data that will enable you to do the exercises below.

You are required to submit a design document in Microsoft Word file including an E-R diagram

and its relational model, and an implementation document in Microsoft Access file that includes

all tables, queries, and the report.

The detailed requirements are given as follows:

• Each writer who works at NewMedia has an ID, a name, an address, and a phone number.

Each address consists of 3 address lines and a postal code.

• Each software tool used in an article preparation at NewMedia has a unique identification

number, a name (e.g., Microsoft Word, Latex, etc), and a platform name (e.g., blog, website,

mySpace etc).

• Each magazine published by NewMedia has a unique identification number, a title, a

copyright date, a format (e.g., online, printed), and a magazine identifier.

• Each article published at NewMedia has a title and an author.

• Each writer may use several software tools for writing an article, and a software tool may be

used by several writers.

• Each magazine has a number of articles on it, but no article may appear on more than one

magazine.

• Each article is written by one or more writers, and a writer may write a number of articles.

• Each magazine has exactly one writer who acts as the chief editor, and a writer may be a

chief editor to several magazines.

In your Microsoft Access database file, create queries for the following:

• How many writers work for NewMedia living in JurongWest?

• How many magazines has J. K. Rowling had articles in?

• List all articles written by R.T. Kiyosaki from Jan 2005 to June 2009.

Create the following report:

• Summarize all writers in the database, listing their name, addresses, phone number, and all

articles written by each writer.

Taidot: Microsoft Access, tietojärjestelmäarkkitehtuuri, SQL, XML

Näytä lisää: database design microsoft access, microsoft access database design, xml tool online, writing tools online, writing articles online magazines, writing article exercises, writing article editor, write xml code website, writers website design, writers tools online, writers magazine, writer editor online, write magazines, write editor online, write articles living, website writer editor, website phone number design, website design writers, website database design software, types report writing, types articles written online, tools design website, tools writers, submit articles magazines, sql design online

About the Employer:
( 2 reviews ) singapore, Singapore

Projektin tunnus: #515354

Myönnetty käyttäjälle:

tootwotrue

Please see PMB for details.

50 $ USD 2 päivässä
(6 arvostelua)
5.4

45 freelanceria on tarjonnut keskimäärin 126 $ tähän työhön

H3Solutions

Hi, We deliver quality with excellence. Please see PMB

150 $ USD 2 päivässä
(11 arvostelua)
5.7
BestWeb4U

I am a expert - professional with an experience of 9 years in making website designs, graphic designs, logo designs, banner, flash,OSCommerce, Joomla + Virtualmart, X-Cart, Zencart, CRELoaded, DotnetNuke, PHP/Mysql, Lisää

250 $ USD 3 päivässä
(11 arvostelua)
5.2
nmppatel

I am an IT professional with 10 yrs experience. I have very good experience with developing ER Diagrams, Ms-Access. I have completed many projects on GAF in Ms-Access skill. I will provide quick & professional service.

150 $ USD 2 päivässä
(14 arvostelua)
4.5
djucuti

I have 10 years of experience in Access

72 $ USD 15 päivässä
(16 arvostelua)
4.5
KellogITSolution

Hello please see your PMB for details of my bid. Thanks

30 $ USD 2 päivässä
(25 arvostelua)
4.4
braghunath

I have been developing applications in MS Access since 2003. I can take up this project immediately. Thanks B.Raghunath

135 $ USD 7 päivässä
(3 arvostelua)
4.1
Yurilad

I can help you.

100 $ USD 5 päivässä
(3 arvostelua)
3.9
zapov

Hi! I'm experienced DBA. I can deliver your project with comments and explanations on database design. Hope to hear from you. Regards, Rikard

130 $ USD 2 päivässä
(2 arvostelua)
3.6
sakshi2004

OCP Certified Professional here. I can send you ER Diagram in a day.

99 $ USD 0 päivässä
(4 arvostelua)
3.5
SSYES

Hi, Ready to provide. Please refer PM . Regards

250 $ USD 2 päivässä
(3 arvostelua)
2.5
saidanor

I can do that. Experienced in database design.

50 $ USD 1 päivässä
(0 arvostelua)
0.0
TowardsTheWorld

Please see your pmb. Regards.

80 $ USD 5 päivässä
(1 arvostelu)
0.0
TuxedoMan

Easy job. I even can do reports in suitable forms.

60 $ USD 2 päivässä
(0 arvostelua)
0.0
kamalkumar1996

Project will done by using ER Digram,10 yrs DBMs experience.

165 $ USD 6 päivässä
(0 arvostelua)
0.0
rama2earn

Hi , I want to do this project keeping view of my past experience in the database design. Thanks Rama

230 $ USD 30 päivässä
(0 arvostelua)
0.0
osky2009

I have designed actual Databases installed in production environments. Pls refer to my PM...Thank you

240 $ USD 20 päivässä
(0 arvostelua)
0.0
a1a

Hi, I'm a Systems Analyst with 10+ years experience in relational database design and implementation. I would be happy to design and implement the described database system for you, delivering a quality system in a tim Lisää

250 $ USD 14 päivässä
(0 arvostelua)
0.0
sachindrasangal

focussed access developer...

200 $ USD 10 päivässä
(0 arvostelua)
0.0
kamrulborni

U can Thust

125 $ USD 10 päivässä
(0 arvostelua)
0.0
anhnk

I have done so many similar projects. Let's start!!

100 $ USD 3 päivässä
(0 arvostelua)
0.0