Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I really need an explanation for this please help me Imagine that you have just been hired to create a database for veterinary office. You

I really need an explanation for this please help me
image text in transcribed
image text in transcribed
Imagine that you have just been hired to create a database for veterinary office. You were provided with an Excel sheet, linked below, that contains an example of some of the information they would like to keep track of. For now, you are requested to do the following: 1. Download the linked Excel sheet. Save it as DHW1_LastnameFirstname, change LastnameFirstname to your last name and first name (10 points) 2. Add a new sheet to the Excel sheet, name it "Relational Design". 3. Determine number of themes (subjects or topics) the Excel sheet covers. Create a table for each theme/subject/topic in the "Relational Design" sheet. Make sure each table is assigned a proper, descriptive name. (20 points) 4. Make sure that each table is a Relation/Normalized. (20 Points). Hint (Primary keys. required). When/if a primary key is added to a table, change the color of the primary key in the table so that it stands out. 5. Review the columns names, remember these will be considered table fields. Make sure the column/field names comply with the naming rules of table fields. ( 20 points) 6. Now to link the tables, you are in need of Foreign keys. What are the foreign keys that you will consider adding to the tables in order to link them? Give these a different color as well ( 20 points) 7. Show tables with data in the columns/fields ( 10 points) Note that all the requirements above should be done in the "Relational Design" sheet requested in step 2. After you've completed, save the Excel sheet and submit it using the link below. 1 Pet Name \begin{tabular}{clr} Pet DOB Owner Last Name & \multicolumn{1}{c}{ Owner Finti Name } & Owner Phon \\ 27-Feb-12 Downs & Marsha & 2018235467 \\ 1-Feb-11 James & Richard & 2017359812 \\ 17-Jul-13 Downs & Marsha & 2018235467 \\ 5-May-13 Frier & Liz & 2018236578 \\ 6-Jun-10 James & Richard & 2017359812 \\ ?7? James & Richard & 2017359812 \\ 11-Dec-09Trent & Miles & 2016347865 \\ 1-Jul-06 Evans & Hilary & 2106342345 \end{tabular}

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

More Books

Students also viewed these Databases questions