Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Garden glory project questions answers

21/11/2020 Client: papadok01 Deadline: 24 Hours

MIS310: Database Management Systems Assignment 3 Total points: 100

The figure below is a data model design for the Garden glory project questions in assignment 2. Use this data model to complete the following tasks.

Figure 1: Garden Glory Project Data Model

The E-R Crow’s Foot model above has the following cardinalities:

Table 1: Garden Glory Project Crow’s Foot Data Model Cardinalities

page1image3861879712 page1image3861881712 page1image3861882064 page1image3861882992

RELATIONSHIP

page1image3862830976

CARDINALITY

PARENT

CHILD

TYPE

MAX

MIN

OWNER

page1image3862854304

OWNED_PROPERTY

page1image3862899136

Non-identifying

1:N

M-O

OWNED_PROPERTY

PROPERTY_SERVICE

Non-identifying to a weak but not ID-Dependent entity

1:N

M-O

EMPLOYEE

PROPERTY_SERVICE

Non-identifying to a weak but not ID-Dependent entity

1:N

M-O

GG_SERVICE

PROPERTY_SERVICE

page1image3861514528

Non-identifying to a weak but not ID-Dependent entity

1:N

M-O

Given that:

· One owner can own many properties, and OWNER data may be entered into the database before any associated property is identified or data for that property is entered.

· One property can have many services performed at it; and OWNED_PROPERTY data may be entered into the database before any service is performed at that property.

· One employee can work on many services, and EMPLOYEE data may be entered into the database before the employee has worked on any service.

· A GG service can be assigned to many Property services, and a GG service may be entered into the database before assigned.

Assignment Details:

1. Transform the data model to physical model (database design). a. Draw the physical entity-relationship diagram (ERD) in Crow’s foot notation using MS Visio

2013/2016. Use only the crow’s foot database notation (template) in MS Visio (10 pts. penalty is assessed if the wrong template is used). Remember what we discussed in class about depicting a physical model table (see figures 5-3, 5-5, 5-8, 5-9, and beyond for guidance). NOTE: Mac users who have difficulty running MS Visio on their Apple Mac’s can use Lucid Charts to develop the physical model then paste the charts in a MS Word file).

b. There must be no many-to-many relationships. c. The physical model must include not only tables, foreign keys and relationships with cardinalities but

also all columns and their data types (do not use char type only, you need to choose the appropriate data types for each column instead) and also display data types on the diagram (10 pts. reduction if data types are not included or displayed).

d. The names must be the same as provided in the data model; clearly label the primary keys and foreign keys.

e. All foreign keys are required, i.e., cannot be NULL. 2. Transform the physical model/database design to an actual database using MS Access 2013/2016 for all tables and relationships, using SQL statements (DO NOT use the Query-By-Example (QBE) feature available on MS Access). The data types for each column in Access should be compatible with those defined in database design above. Populate the tables with real data (you can make up) and each table needs to have at least 5 rows.

a. Please enforce referential integrity constraints when necessary and ensure the values satisfy the

constraints. Submission Guidelines: 1. This is an individual assignment. 2. Draw the physical model ERD in a MS Visio file and name it based on this notation: FirstnameLastnameHW3.vsdx (Note: Do not user a space in the file name). For Mac users, please get a screen shot of your model and past it in a MS Word submission. 3. Name the MS Access database file following this notation: FirstnameLastnameHW3.accdb (Note: Do not user a space in the file name). 4. Submit only the electronic copy of both Visio (MS Word for Lucid Charts user) and Access files on Blackboard

a. Upload and submit the two files on Blackboard before. b. You are strongly advised to submit the electronic copy at least 30 minutes before the deadline to avoid any technical issues. c. Make sure you submit the correct file and that the submitted files can be opened; the grading is based on your submitted files only. Caution: submit the actual Access database file that ends with .accdb, not the .laccdb file. You are strongly advised to verify the integrity of your submission by opening the files yourself after the submission. You could receive 0 point if wrong files are submitted or the submitted files cannot be opened by the campus computers. d. Late submissions are subject to the penalties outlined in the syllabus. Absolutely no exceptions! Submission system remains open till 48 hours after the deadline, and you will not be able to submit afterwards.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Essay Tutor
Homework Guru
Buy Coursework Help
Quality Homework Helper
Helping Hand
University Coursework Help
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$65 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$62 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Radioactive dating game phet answers - Disaster recovery - Sanjose config ip address 192.168 2.1 255.255 255.0 - Cartoon solution focused brief therapy - Two syllable words with vce pattern - How to exit from hive - Starbucks job analysis - Cpt code for dermabond wound closure - CC W 6 D - Fisher decoding the ethics code - Arti sood economy rent a car - Https accounts google com signin v2 challenge pwd - Lorance v at&t technologies - Your furniture store sells two types of tables - C program to find inverse of a matrix - 495 week 5 - Glen eldon twisted trunk reserve shiraz 2013 - Meichenbaum self regulated learning - Email Letter - Human resource exam - Instruments of darkness macbeth - What is insolation in geography - Infomation tech - 1002 2 - Irish setter uk and ireland - To be or not be soliloquy analysis - Loose boots monica on rel - Age structure diagram worksheet - Writing activity 150-300 words - How to calculate death rate per 100 000 - Zero one two three address instructions - Operating system concepts 9th edition ppt - Shape of the state of nevada - Blank training matrix template - Experiment 1 observation of mitosis in a plant cell - What are some equivalent fractions to 3 4 - Ethical behavior within firms in relation to financial management - Dividing decimals games jeopardy - Butterworth vs chebyshev filters - Progressive writing assignment - An inconvenient truth worksheet - Alam company is a manufacturing firm - Marlowe park medical centre - Telstra shared data plan - Ray cupple bought a basic car costing - Pluralism and assimilation in rites of passage - Wiley plus accounting answers chapter 6 - Erico lightning protection system - Penn foster math placement test - In-the-News Topic: Any Topic Relevant to an Enterprise CIO - Strategies to restructure a diversified company's business lineup involve - 1/3 of 5/8 in its simplest form - Nature the gentlest mother - Surfers paradise outrigger canoe club - Carnival cruise mission statement - Case Study for Marketing New Product Strategy - Firms that lack competitive advantages will - British safety council membership cost - Https usahire opm gov assess - How the Superbowl Can Improve My Relationship - Sex linked traits virtual lab answers - MINI CASE ANALYSIS 1000 WORDS - How to calculate percentage error - Gordon roddick net worth - Why does neoptolemus kills priam - Mkt 421 favorite brand paper - Social work treatment interlocking theoretical approaches 5th edition - Brief exercise 4 3 brisky corporation - Missouri Can Company - Stick diagram of xor gate - In aristotelian terms happiness is - Blue butterfly meaning japan - Paws and claws gornal - Human Resource Management Essay (Half Done) - Aftershock beyond the civil war - Sysml block definition diagram tutorial - Blowout and non blowout pipette - Donnie wahlberg sixth sense weight loss - Catton grove primary school - Syrian colloquial arabic mp3 - 4 figure grid references worksheet - Ball state men's volleyball - The Hyatt Regency Walkway Collapse - Module 03 Project - Strategy - Samovar and porter definition of culture - Dc filter capacitor calculation - The gaap matching principle requires revenues to be matched with - A to Z Problem Solution -+91-9829866507 @ll Love Marriage Problem Solution Molvi Ji - Microorganisms concept map - Three official mechanics emphasize covering primary areas of responsibility - Drawing lewis dot structures worksheet - Seeing conservation through the global lens - Designspark mechanical 2d drawings - Ben and jerry's case summary - Mcdonald's corporate social responsibility pdf 2018 - Summary of the loneliness beyond poem - Wbs for a coffee shop - Citric acid plus naoh - Service blueprint of food delivery - How do you say the spanish alphabet