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 04:30

Kyle, a receptionist for a building supply company, recently won an award for saving his company money on their phone system. after being presented with kyle's research, the company changed the way in which it made long-distance phone calls and cut their expenses in this area by 75 percent. the new system the kyle's company most likely adopted was wired communications switching stations voip hdtv

Answers: 3

Answer

Computers and Technology, 22.06.2019 14:30

What percentage of companies is projected to use social media to locate new employees in 2012

Answers: 2

Answer

Computers and Technology, 23.06.2019 20:00

What software programs are used to to create professional publication? a.) graphics programs b.) word processors c.) page layout programs d.) spreadsheet programs

Answers: 2

Answer

Computers and Technology, 24.06.2019 10:20

Write a program that keeps asking the user for new values to be added to a list until the user enters 'exit' ('exit' should not be added to the list). these values entered by the user are added to a list we call 'initial_list'. then write a function that takes this initial_list as input and returns another list with 3 copies of every value in the initial_list. finally, inside print out all of the values in the new list. for example: input: enter value to be added to list: a enter value to be added to list: b enter value to be added to list: c enter value to be added to list: exit output: a b c a b c a b c note how 'exit' is not added to the list. also, your program needs to be able to handle any variation of 'exit' such as 'exit', 'exit' etc. and treat them all as 'exit'.

Answers: 2

Answer

You know the right answer?

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

users...

Questions