Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following scenario: Each computer program, whether written in Python, JavaScript, C++, or any other languages, is made up of statements. Each statement contains

Consider the following scenario: Each computer program, whether written in Python, JavaScript, C++, or any other languages, is made up of statements. Each statement contains variables which can be read, updated, and in some languages, deleted. John is an application developer and he likes to set up a database to keep track of how the variables are used in each of his programs. 1. Create a relational ERD and insert the diagram here: 2. Write out the CREATE TABLE statements for your ERD: 3. Come up with an additional requirement on your own to the above scenario which will require at least 1 additional entity to your ERD in Question 1. Be reasonable and realistic! Describe the addition requirement: 4. Extend the ERD from Question 1 and include the diagram here: (highlight the new entities in a different color using the Fill tool in Visio)

5. Before you continue, calculate the following: Write down the current time (doesnt matter whether you are using a 12- or 24-hour clock!): What is the hour: Divide by 2: What is the remainder? Your answer should be either 0 or 1. Write down the remainder here: Using this remainder from your calculation, 1) identify the relational operator below, 2) come up with some sample data for a table, and 3) give an example of applying that relational operator on your sample data. (E.g., if the remainder of your calculation is 0, you need to provide an example of applying the SELECT operator to a table from question 4.) Show your table with your sample data and the result of applying the relational operator on your table(s). 0: SELECT 1: PROJEC

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

Modern Database Management

Authors: Donald A. Carpenter Fred R. McFadden

1st Edition

8178088045, 978-8178088044

More Books

Students also viewed these Databases questions

Question

List the advantages and disadvantages of the pay programs. page 505

Answered: 1 week ago