database programming doing a Composition diagram and ERD diagram

Design conceptual DB for the visitor (guest user) of

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

https://www.coffeesuppliesdirect.co.uk

.

Userview 1 :guest visiting the website

You have already analyzed this and submitted the screenshots. Based on your analysis design and submit your report containing the following:

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
  1. Title page (with team logo, name, motto, team member info and version #)
  2. Screenshots, assumption and any other explanations
  3. Composition diagram
  4. ERD
  5. Documentation (submit only entity document and relationship document

Logo of your team
Team Name
Student nos Names
Analysis of the home page
*: the p’cture ‘s retr[‘eved random;y from the projects
Assumptions observations
Clarification about the Project
The focus of the analysis must be product.
The web site has a lot of information that we may not store in the DB.
Below you will see some screenshots band questions that will help you when identifying the
requirements:
1- The composition diagram that you need to submit does not have to cover the whole web
site. Focus on the product.
…….
Above you can see two screenshots with some comments. Scroll down and take screenshots to cover
all properties of a product including reviews. You must analyze a couple of different products to
understand exactly what you have to store in the DB.
2- Design one composition diagram for product. Please note that you should normally analyze a
large number of products, but you must design only one composition diagram.
One of your friends requested (insisted
) that I provide the initial step in the design
process, so here it is.
Composition diagram of products for coffeesuppliersdirect.co.uk
3- On the main page focus on the menu items at the top and decide if they are categories.
In the picture above focus only on coffee and tea related products. Consider the menu item
“reduced”. Even though it was shown as a menu item, is it represented in the same way in the DB as
coffee/tea/coffee pod?. In other words, is this a category?
4- Consider the first menu item “Tassimo” above, if it is just a brand name for a coffee or a
machine, you do NOT have to analyze it separately. It will be included in your design when
you analyze tea and coffee (and may be coffee pods). You can write this as an assumption.
5- The next assumption you have to make is whether coffee pods a category or if it can be
considered as a sub category of coffee. Write your assumption try to justify your choice. Why
do you think it is a separate category(—in this case you will have three categories coffee pod,
coffee and tea) ? Or if you decide that it is a subcategory of coffee (–in this case you will have
two categories coffee and tea) why do you think so?
6-
Next you have to decide how many levels of categories you have. At this point you should
click on the links and follow them until you reach a product. You can use your logic to
simplify the design. For example, even though the website shows instant coffee filter ground
coffee beans and coffee brands at the same level, we usually represent brand using an entity
called brand or company. To give you a crude example: We can say “nescafe gold” belongs to
the “instant coffee” subcategory that is under the “coffee” category. The brand of “nescafe
gold” is Nescafe. Please note that this is just an example, and you have to decide how many
levels of categories you have.
Check both tea and coffee to see how many levels you need. Try to find a simple solution
that can be used for any product.
7- Once you have understood how to represent products and categories you can start drawing
your ERD. Note that you will have to make some assumptions. In that case it is advisable to
make assumption that will make the design simple.
SAMPLE DATABASE DOCUMENTATION
Conceptual Design
Use Peter Chen notation for drawing the ERD.
You should add all attributes and clearly show the
PKs.
STAFF
d
This ERD is given without attributes but you must
show all attributes if possible.
ACADEMIC
STAFF
ADMINISTRATIVE
STAFF
Member
Of
Works
For
RESPONSIBLE
FROM
DEPARTMENT
OFFER
COMMITTEE
COURSE
Prerequisite
Of
ENTITY TYPE DOCUMENT:
ENTITY NAME
DESCRIPTION
ALIASES
OCCURENCES
STAFF
Employees working in the
department
Employee
Staff works for IT department.
ACADEMIC STAFF
Employee teaching courses
Teacher,
Professor
Each course is taught by a an academic staff member.
ADMINISTRATIVE
STAFF
DEPARTMENT
CATEGORY
GALLERY
Employee responsible from
nonacademic tasks
Division of a school/faculty.
Type of courses offered.
Photos of the department and
student life.
Courses the department offers.
Courses that depend on other
courses in the department.
Staff grouped for a specific task
COURSE
PREREQUISITES
COMMITTEE
There must be one administrative staff responsible from each
department.
Each department offers many courses.
A category contains one to many courses.
Department can have many photos in the gallery.
Department has many courses.
Some courses has one or many courses as prerequisites in the
department.
A staff can be a member of one to many committees.
RELATIONSHIP TYPE DOCUMENT:
Relationship Type Entity Type
Cardinality Ratio
Participation
Works for
M
1
1
M
1
M
1
M
1
M
M
1
M
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Optional
Mandatory
Optional
Mandatory
Optional
Optional
Mandatory
Optional
offers
MemberOf
PrerequisiteOf
Isa
Has
Staff
department
Department
course
Staff
Committee
Course
Course
Staff
Academic Staff
Administrative Staff
Reference
Curriculum
ATTRIBUTE DOCUMENT:
Entity/Relationship
Type
Attribute
Staff
Name
First Name
Last Name
SID
OFFICE NO
Description
Data Type and
Length
Constraint
Staff first name
Staff last name
Staff unique no
Staff office no
Char(25)
Char(25)
Varchar2(7)
Varchar2(5)
AK
PK
Default
Value
Alias
Null?
No
No
Derived?
Membership
Committee
Curriculum
Course
E-mail
Phone_NO
Title
Status
Office hour
e-mail address of staff
Staff phone no
Staff prefix
Picture
Staff photo
Varchar2(5)
Position
Start_date
End_date
CID
Name
Cuid
Program
Semester no
C_code
Semester
Staff position
Membership start date
Membership end date
Committee unique no
Name of committee
Curriculum unique no
Curriculum Program
Semester course offers
Course unique no
semester the course
offers in the curriculum
Name of the course
Course objectives
Tutorial hour for the
course in a week
Lab hour for the course
in a week
Lecture hour for the
course in a week
Char(10)
Date
Date
Varchar2(10)
Char(20)
Varchar2(7)
Char(15)
Course credit
Number(1)
C_title
Desc
Hours
Tutorial
Lab
Lecture
Credit
ECTS
Varchar2(20)
Number(11)
Char(15)
Staff office hour
Varchar2(7)
Varchar2(15)
Varchar(20)
Varchar(50)
Varchar2(5)
PK
No
PK
No
PK
No
Varchar2(5)
Varchar2(5)
No
EMU
University course credit
Number(1)
Reference unique no
Picture unique no
Name of picture
Varchar2(7)
Varchar2(10)
Char(15)
Char(15)
Char(20)
Varchar2(7)
Char(15)
Char(50)
CourseCategory
Reference
Gallery
Activity
Refcode
PID
Picture
caption
title
Act_ID
visibility
desc
PK
PK
No
Title
Activity name
Activity unique no
Place taken place
Purpose of
announcement
Announcement date
Announcement unique
no
Announcement name
Visibility
place
Date
Category
CAID
name
Category unique no
Category name
Varchar2(7)
Varchar(20)
PK
Department
D_code
Name
num
question
Answer
Prid
Department unique no
Department name
Unique no
Questions post
Answer for the question
Prerequisites unique no
Number(2)
Char(25)
Varchar2(7)
Char(50)
Char(50)
Varchar2(7)
PK
Announcement
An_date
An_ID
F.A.Q
Prerequisites
date
Varchar2(7)
PK
PK
Char(20)
PK
ATTRIBUTE DOMAIN DOCUMENT:
Domain Name
Domain Characteristics
Membership_start_date char(7); First three characters month abbreviation,4th character
underscore, last 3 characters sequential number
Curriculum_program
Char(15);(‘Bachelor’ or ‘Masters’)
Examples of allowable
values
Columns
JAN_001, JAN_999,
APR_067
B_tech , M_tech
Start_date(membership)
Program(curriculum)

Still stressed from student homework?
Get quality assistance from academic writers!

Order your essay today and save 25% with the discount code LAVENDER