1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
koban [17]
3 years ago
7

Create the tables and appropriate constraints based on the following ER diagram. Use appropriate data types. Note that the size

column should only accept S, M, or L. In addition the price column should only have values greater than zero. All columns in both tables are required. ====================== CATEGORY table: Category Cid Description ====================== PRODUCT table: pid description cid (fk) Price Size (S/M/L)
Computers and Technology
1 answer:
SpyIntel [72]3 years ago
7 0

Answer:

See explaination

Explanation:

CREATE TABLE CATEGORY

(

cid int NOT NULL,

description varchar2(1000),

PRIMARY KEY (cid)

);

CREATE TABLE PRODUCT

(

pid int NOT NULL,

description varchar2(1000),

cid int,

price int,

p_size varchar2(1),

CONSTRAINT chk_price CHECK (price>0),

CONSTRAINT chk_size CHECK (p_size in ('S','M','L')),

CONSTRAINT fk_cid FOREIGN KEY (cid) REFERENCES CATEGORY(cid)

);

You might be interested in
You want to set the sticky bit on an existing directory, subdir, without otherwise altering its permissions. to do so, you shoul
nikklg [1K]

If you want to set the sticky bit on an existing directory, subdir, without otherwise altering its permissions. to do so, you should type chmod a <u>t  <subdir>.</u>

<h3>What is Subdir?</h3>

The Definition of the term subdirectory is known to be a kind of an organizational directory that can be seen on a computer.

It is known to be one that can be found inside another directory  such as a subfolder. It is seen as the file a person is looking for and it is one that needs to have an extension.

Therefore, if you want to set the sticky bit on an existing directory, subdir, without otherwise altering its permissions. to do so, you should type chmod a <u>t  <subdir>.</u>

Learn more about directory from

brainly.com/question/14845522

#SPJ1

See full question below

You want to set the sticky bit on an existing directory, subdir, without otherwise altering its permissions. To do so, you should type:

chmod a+_____ <subdir>

- s

- p

- b

- t

6 0
2 years ago
Which type of operating system is usually used in personal computers?
joja [24]

Answer:

Microsoft Windows

Explanation:

7 0
3 years ago
Read 2 more answers
In the function below, use a function from the random module to return a random integer between the given lower_bound and upper_
sladkih [1.3K]

Answer:

import random

def ran(lower_bound, upper_bound):

   return random.randrange(lower_bound, upper_bound)

print(ran(3, 8))

Explanation:

The programming language used is python.

Modules are imported using the import keyword. In the first line the random module is imported.

A function ran is defined and it has two parameters, lower and upper bound that wll be passed to the function from random module.

The random module is a module that is used to generate random numbers, it is a very common module in programming, some of the popular functions in the module are random.randint and random.randrange. There are several other functions but these are the most common. the randint(a, b) takes two arguments and returns a random integer between the two arguments.

randrange(start, stop, step); It can take up to three arguments but has only compulsory argument that must be given for it not to generate an error and that is the stop.

when only the stop is defined, it assumes the start as zero and creates a range from 0 - stop and returns a random number within that range.

When start and stop arguments are given, it returns a number within the range of start - stop.

Start and stop must be given for there to be a step, if the step is given, it means the array containing the range of numbers will skip a step after each number.

The program makes use of the random.randrange(start, stop) and the upper and lower bounds are passed as its arguments.

Finally, the function is called and its return value is printed to the screen.

6 0
3 years ago
TRUE/FALSE
algol [13]
<h2>Answer:</h2>

Following are given answers to each part with explanation:

<h2>Explanation:</h2>

1. lt takes multiple clock cycles to access data from memory.

The statement is TRUE.

Accessing data from memory acquires two steps. In first step the address is read and in second step we go to the address in order to access the data.

2.Each byte of memory has a unique address.

The statement is TRUE.

Each byte in the memory attains a unique address therefore we can access the data residing at each byte specifically by giving address.

3.The total memory used by all running programs can never be larger than the computer's physical memory.

The statement is TRUE.

The running parts are always a sub part o a system so combining them all cannot exceed the total size of computer's physical memory.

4.The lower half (or least significant half) of the EBX register is called BX.

The statement is TRUE.

BX is he least significant or lower half of the register EBX (extended BX).

5.The following data locations are in order of fastest access time to slowest access time: cache, registers, main memory.

The statement is TRUE.

Yes the order of data locations from faster to lower is given correctly:

Cache is accessed faster than registers and in the end comes main memory.

6.The ALU performs only addition, subtraction, multiplication, and division operation:s

The statement is FALSE.

ALU is an abbreviation of Arithmetic Logic unit. So it performs arithmetical operations such as addition, subtraction, multiplication, and division as well as the Logical operations that are AND OR NOT XOR.

7. The control unit (CU) coordinates the sequencing of execution steps in an instruction cycle.

The statement is TRUE.

As obvious from the name Control unit (CU) has assigned the coordination of execution of steps in sequence.

8.The EIP register is updated when an instruction is fetched.

The statement is TRUE.

Whenever the user retrieve any instruction from EIP or fetch the instruction from it. EIP gets updated.

9.The step to fetch an operand is always necessary in the instruction cycle.

The statement is TRUE.

Most of the Instructions demand an operand in the instruction cycle so that they could be operated on. While some instruction not demand the operand such as Exit. But majority demands the operand so it is true.

10.In an instruction cycle, the operands are fetched before the instruction is fetched.

The statement is FALSE.

The first part of instruction cycle is to fetch the instruction, whereas the operands are fetched after it. So the statement get FALSE.

<h3>I hope it will help you!</h3>
5 0
3 years ago
Why do some computer systems not allow users to activate macros?
Tems11 [23]
Macros can carry viruses that can harm a computer.
4 0
3 years ago
Read 2 more answers
Other questions:
  • What is the value of the variable phones after the execution of the following code? phones = {'John': '5555555', 'Julie' : '7777
    6·1 answer
  • Rebecca received the following e-mail from her boss: I NEED ALL EMPLOYEES TO WORK LATE ON SATURDAY. NO EXCEPTIONS! What is the m
    13·2 answers
  • Debugging is not testing, but always occurs as a consequence of testing. <br> A) TRUE<br> B) FALSE
    13·1 answer
  • When viewing data entered into a spreadsheet, the columns identify _____.?
    5·1 answer
  • Troy, an aspiring screenwriter, aspires to work with a famous director known for his philanthropic work. Troy gets an appointmen
    5·1 answer
  • ________________are programs that designed to help users to be more productive with their personal tasks
    11·2 answers
  • Write a function called show_info that takes a name, a home city, and a home state (a total of 3 arguments) and returns a full s
    12·1 answer
  • Which shortcut key combination will move the cursor to the beginning of the line?
    13·1 answer
  • What is the primary purpose of source code editor features such as keyword hi lighting and auto-completion A.to speed up the cod
    7·1 answer
  • Write a program that lets the user enter four quarterly sales figures for six divisions of a company. The figures should be stor
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!