Computers and Technology, 27.11.2019 20:31 angelicar1160

Write a script that implements the following design in a database named mywebdb:

users table colums are : userid(the is the primary key), emailaddress, firstname, lastname

downloards table colums are: downloardid(the is the primary key), userid, downloarddate, filename, productid

product table colums are: productid(the is the primary key), productname

create a new database called mywebdb using the default settings.(if the database already exists, delete it and then recreate it.)

write code to create the users, download and products table.

write code to define the userid column in the users table, the productsid column in the products table, and the downloadid column in the downloads table as primary keys and identity columns.

in the downloads table, write code to define the userid and productid columns are the foreign keys.

write code to setup table relationships based on above diagram

write code to define the columns so none of them allow null values

write code to create a unique index on the emailaddress and productname columns and a regular index on the downloaddate column.

include any indexes that you think are necessary.

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 13:00

Write a program which asks you to enter a name in the form of first middle initial last. so you might enter for example samuel p. clemens. use getline to read in the string because it contains spaces. also, apparently the shift key on your keyboard doesn’t work, because you enter it all lower case. pass the string to a function which uses .find to locate the letters which need to be upper case and use toupper to convert those characters to uppercase. the revised string should then be returned to main in the form last, first mi where it will be displayed.

Answers: 1

Answer

Computers and Technology, 22.06.2019 16:30

Technician a says that a dry sump system uses no oil storage sump under the engine. technician b says that a wet sump system uses no oil storage sump under the engine. who is correct?

Answers: 3

Answer

Computers and Technology, 23.06.2019 02:00

Which demographic challenge is europe currently experiencing? a. an aging and decreasing population b. a baby boomc. an unequal distribution between males and females d. a large group of teenagers moving through the school system(i chose a but i'm unsure)

Answers: 1

Answer

Computers and Technology, 24.06.2019 13:00

Ais a built in formula in spread spread a is any math process such as addition or subtraction. options are function and operation

Answers: 1

Answer

You know the right answer?

Write a script that implements the following design in a database named mywebdb:

users...

Questions