Description
Unformatted Attachment Preview
BCIS 4301 Lab Assignment #1 Data Models and the Relational DB Model
1. You have been selected to create a new database for a small summer camp in Vermont. The
database will track campers, their registration, their payment, their bunk assignment, and their top
three preferred activities. The database should also track camp counselors, their bunk assignments
(one counselor to each camper bunkhouse), and their top three activities they supervise.
a) List what tables you think will be needed for this project.
b) Discuss what an entity will be in each table. I’ll give you one as an example…..A camper will be
an entity in the camper table.
c) Identify at least three attributes for each entity. Continuing with the example, a camper will
have a first name, last name, address, city, state, zip code, home phone, gender, age, etc.
d) Define which relationships exist between tables. For example, a camper will be related to a
bunkhouse.
e) Determine if relationships are 1 to 1, 1 to Many or Many to Many. A camper can only be in one
bunkhouse but a bunkhouse will have many campers.
f) Now take a closer look at your Many to Many relationships. The relational database model
cannot support this type of relationship so you have to break them into two tables with a linking
table in between. Explain how you will correct these many to many relationships in your
database. For example, a child can have many parents in the parent table ( a mom, a dad, a
stepmom, etc.) and a parent can have many children at the camp (can send two siblings). So I
would need a separate parent table from the camper table and I would have a linking table in
between that had the parent_id and the camper_id together.
g) For each table, write the shorthand to represent each table used throughout the chapter. Put
the table name and then in parentheses, list the attributes. Underline the field that you will be
using as the primary key. There’s a better example in chapter 4 on page 115 that explains the
system they’ve been using in chapter 3!
h) Write at least two business rules that will act as constraints on the problem. For example, a
camper must be at least 8 years old to attend camp.
2. Your next project entails your company creating a database for a small music store. The store sells
products to customers, so you will need a basic sales database that allows customers to buy
instruments, sheet music, supplies, etc. In addition to selling products, the company also arranges
music lessons with local teachers. There are currently 32 teachers that teach a variety of
instruments and charge different hourly rates for their lessons. Some teachers only teach one
instrument while other teachers may offer lessons on multiple instruments. Lessons should be
incorporated in the sales database as a product so customers can “order” them.
Repeat steps a-h from question #1.
3. Create a data dictionary for one of the projects above. Use the example on p.88 in the textbook for
format.
4. Create a relational diagram for one of your projects above. See the example on on page 96, Figure
3.26 page 98 or Figure 3.30 You can use a database tool for this, you can use Microsoft Visio if
you’re ready to start playing with that tool, you can use Word and the drawing tools, or you can
hand draw it and send me a picture as an attachment. If you hand draw your diagram, make sure
that all aspects of the diagram are legible. If not, you’ll miss credit!
Submit your file(s) in Canvas by the due date.
Purchase answer to see full attachment
Purchase answer to see full attachment
Explanation & Answer:
3 pages
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Hey, have a look
The tables that will be used include students, activities, fees, login, teacher, teacher roles, parents
and parents.
Tables and entities needed will be,
#1 student(campers),
st_name
st_id
st_mobile
st_add
st_email
st_pass
#2 activities,
act_name
act_id
act_fees
act_type
act_min_age
#3 fees,
fees_id
fees_amt
fees_act_id
fees_type
fees_desc
#4 login,
login_id
login_role_id
login_user
login_pass
#5 teacher,
teacher_name
teacher_id
teacher_mob
teacher_email
teacher_add
#6 teacher roles,
role_id
role_name
role_desc
#7 parent,
student_sent
paren
t_id
parent_
name
parent_
mobile
parent
_add
student_id
student_name
teacher ->(has)->teacher_roles (m:m) since one teacher can have many roles and many teacher
can handle one role,
student/teacher ->(has)_>login (1:1) since ev...
Review
Review
Anonymous
Great! Studypool always delivers quality work.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Content
website advert
With reference BSN or RSN write an advert for a graduate position. The advert should be brief an example of facebook...
program of the
Problem I -(50 points)Steve Smith is a restaurant owner who wants to spend his $10,000 to modernize his restaurant by adap...
Machine learning Future of Quality Assurance Discussion
NO references after the 2018 year. Pls follow the same instructions and context. Own content, identify and clearly state ...
Windows Application Security Paper Paper
Hello,Can you please write 4 pages document about the below topic.1st Page: Access Controls in Microsoft Windows1nd Page: ...
Elastic and Inelastic Traffic
Write a three to four (3-4) page paper in which you:Outline a plan for the development of an addressing and naming model i...
HCM 500 Electronic Medical Record Systems Presentation
information technology can be used to assist health care organizations in the ability to provide access to health care org...
Information Security Issues
Cybersecurity is defined as the protection of computerized systems from any kind of interruption, or disruption. It can fu...
Authenticating Workstations
The intricacy of this matter is often a twisted one because as much as the users seem to feel inclined to the freedom to a...
Word Doc
...
