Buy Transform Data Model Discussion

Buy Transform Data Model Discussion
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
Buy Transform Data Model Discussion
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
Buy Transform Data Model Discussion
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:
Buy Transform Data Model Discussion
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.
Buy Transform Data Model Discussion
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.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 3234125597

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 30% with the discount code HAPPY