Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Given a mini-world ZENTERGY which has units of employee, customer, outage, teaminField, vehicle, location and invoice. Draw a graph (with nodes as an entity

image text in transcribed
1. Given a mini-world ZENTERGY which has units of employee, customer, outage, teaminField, vehicle, location and invoice. Draw a graph (with nodes as an entity and connections between nodes as a relationship) that conceptually maps this universe of discourse as a database system. See the attached sample. Drawing must be professional. Do not use lines with arrow, use simple and proper naming. 2. Give a snap-shot of meta-data database for the ZENTERGY database described in question-1. 3. Assume that the ZENTERGY data is stored in three different text files of employee.csv, teaminField.csv, outage.csv. The first line of each file has attributes. The lines following the first one will have values for each attribute. The files should have appropriate attributes to keep track of outages and relevant data. 1. Enter some data to each file such that redundancy will occur. Explain how redundancy is occurring out of these three files. 2. Provide a snapshot of these three text files

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

Question

Make eye contact when talking and listening

Answered: 1 week ago