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,
• 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
• 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.
45 freelanceria on tarjonnut keskimäärin 126 $ tähän työhön
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.