Database design (microsoft access)
$30-250 USD
Paid on delivery
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.
Project ID: #515354
About the project
Awarded to:
44 freelancers are bidding on average $128 for this job
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.
Hi! I'm experienced DBA. I can deliver your project with comments and explanations on database design. Hope to hear from you. Regards, Rikard
Hi , I want to do this project keeping view of my past experience in the database design. Thanks Rama
Hello, smartITz is applying a bid, a company with 4+ years of experience in providing smart IT solutions. We are basically in INDIA and providing services to all over world. We have a smart eye for perfection becau More
I have already developed applications in MS Access since 2003. I can take up this project immediately.
Hello, With 7 - 8 years experience We are doing good with C# and Vb.net and as back hand Ms-Access and mySql. We have done many such application successfully, so We think we can do better work to you. If you positive More