Provide pros and cons of using a database vs a spreadsheet
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.
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 (Experiencing MIS, pg 125-26) as well as the powerpoint slides. 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 two tables. (Experiencing MIS, pg 127-29).
(5pts) Table 1 will be a customer table and should have fields (columns) that describe information you would want to know about a customer – include 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 three records (rows) of customer information.
(5pts) Table 2 will be a jobs table and should have fields (columns) 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 four records (rows) of job information. One customer from section (a) above should have more than one job listed in the jobs table. Have at least 5 fields, this includes the foreign key from step c below.
(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 specific 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 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. (25+ words)
If personal,provide aspecificre commended product
This is a video that explains it https://www.3cmediasolutions.org/privid/388632?key…
Requirements: 1-2
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
