Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started