Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bart Simpson has come to you to help him organize his lawn cutting business. Skateboards and slingshots are not cheap, so Bart had to grow

Bart Simpson has come to you to help him organize his lawn cutting business. Skateboards and slingshots are not cheap, so Bart had to grow his business to afford his hobbies. However, Bart is losing track of jobs and is asking you to help him get organized. NOTE - You may complete this with your popsicle pair or groupmate, but NOT using divide and conquer approach. You must work on each question together and submit separately. If you worked with your PP/groupmate, please indicate so. 1) (4pts) He was thinking about either using a spreadsheet or a database to manage customers and asked you to explain the difference. You remembered that section Q1 in the text book discussed this (MIS Essentials, page 113). Provide pros and cons of using a database vs a spreadsheet (25+ words) 2) After answering (1) above, you decide that a database would be better in the long run. You decide that Bart will need at least two tables. a. (5pts) One table will be a customer table and should have columns (fields) that describe information you would want to know about a customer have at least 3 fields. Select or create one field to be the primary key (this column should the left most column with yellow fill). Enter at least two rows (records) of customer information b. (5pts) The other table will be a jobs table and should have columns (fields) that describe information you would want to know about a job. There is likely nothing unique in this table, so it will be best to create a field called JobID that will be your primary key for this table (this column should be yellow fill). Enter at least three rows (records) of job information. One customer from section (a) above should have more than one job listed in the jobs table. Have at least 4 fields this includes the foreign key from step c below. c. (3pts) The magic of a relational database is the relationships between the tables. Since there is a one to many relationship between customers and jobs (i.e., one customer can have many jobs, but a job can only have one customer), you will need to put a copy of the applicable customer primary key in each row of the jobs table as a foreign key since jobs is the many table. This will relate the records together. The foreign key (MIS Essentials, pgs 115-116) should help you with this. The foreign key column should be the right most column with light blue fill. 3) (3pts) Bart was doing research on DBMS and discovered that there are two major types of DBMS personal and enterprise. Assuming that Bart and maybe Millhouse will be the only two persons on the DBMS at any given time, would you recommend a personal or enterprise DBMS and explain why. If personal, provide a recommended product. (25+ words)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Experts Guide To SQL

Authors: Frank Lusardi

1st Edition

0070390029, 978-0070390027

More Books

Students also viewed these Databases questions

Question

=+and show that the infimum and supremum are always achieved.

Answered: 1 week ago

Question

s

Answered: 1 week ago