Question: B . Based on the GEO Overview, list at least 3 entities that are defined in GEO database schema. Create a data dictionary for each

B. Based on the GEO Overview, list at least 3 entities that are defined in GEO database schema. Create a data dictionary for each of these entities. Each data dictionary should contain:
Attribute name,
Datatype,
Constrains,
Whether this attribute is primary key or foreign key
Description.
If some information that is not available on the GEO website (e.g., primary and foreign keys), use your best guess to fill out the data dictionaries.
B. Based on the GEO Overview, list at least 3 entities

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

B . Based on the GEO Overview, list at least 3 entities that are defined in GEO database schema. Create a data dictionary for each of these entities. Each data dictionary should contain: Attribute...

Q:

STEP 1: Create Data Dictionary for provided elements As the DBA for your company, you have decided to install a new version of the MySQL database to replace the current database version being used....

Q:

E-R Model - Entities The modeling, design and creation of a databse is an iterative, top-down process. First, the designer must gather information to define specific requirements. This will involve...

Q:

As a database developer at the creative Developers Company (CDC), you got a new project to develop a cloud database system for a Cinema named the Movie Zone. CDC Company conducted a meeting with the...

Q:

6 Match the database model type with its characteristic. (2 pts ee = 20 pts) Table name: PAINTER Primary key: PAINTER_NUM Foreign key: none PAINTER_NUM PAINTER_LNAME PAINTER_FNAME PAINTER_INITIAL 123...

Q:

Please help me with the questions below, I am using Oracle Data Modeler for this assignment: The objective of the assignment is to develop a database to support an on-line auction site called Nifty...

Q:

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

Q:

Write a project management plan. we have a template and project description. we need to edit the template(table of contents) with our own ideas. CPSC 8820-01 Project Management Plan Your Unique...

Q:

Lab 3 Creating Profiles, Users and Roles Overview: In this lab, you will demonstrate you are comfortable creating users, profiles and roles. You must connect to the provided AWS Oracle RDS...

Q:

TASK 1: MAKE UPDATES AND CORRECTIONS Based on Part 1 Comments-20 Points: 1. Update the data model: Make any required changes to your design based on the comments provided for Part 1 of the project....

Q:

A temporary construction elevator is to be designed to carry workers and materials to a height of 90 ft. The maximum estimated load to be hoisted is 5000 lbf at a velocity not to exceed 2 ft/s. For...

Q:

Suppose that the market for painting services is perfectly competitive. Painting companies are identical; their long-run cost functions are given by TC(Q)=6Q^3-30Q^2+200Q Market demand is...

Q:

3 3 of 3 5 Concepts completed Multiple Select Question Select all that apply A reversing entry can be described as a ( n ) : entry whose purpose is to simplify a company's record keeping. entry that...

Q:

A rule of thumb offered for the sequencing of influence tactics is to: Question 2 1 Select one: a . first mirror the influence tactic of the other person, then try your own. b . begin with the...

Q:

What magazine and ads did you choose to examine?

Q:

2. Have you developed your thesis statement as a proposition of fact, value, or policy?

Q:

4. Have you worked to ensure that your speechand your deliverywill help the audience to engage in central processing?