HomeworkLib
Question

Create a database with one table giving computer terms and acronyms, a definition, and link to...

Create a database with one table giving computer terms and acronyms, a definition, and link to a website for additional information. The second table lists important people in computers and what they are famous for.

CMSC110

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

#command for creating the database

CREATE DATABASE computerinfo;

#command for creating the first table

CREATE TABLE compinfo( Terms varchar(255), Acronyms varchar(255), Definition varchar(255), Link varchar(255) );

#command for creating the second table

CREATE TABLE people( Name varchar(255), Description varchar(255) );

0 0
Add a comment
Know the answer?
Add Answer to:
Create a database with one table giving computer terms and acronyms, a definition, and link to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Provide Query to create Database In this database at least a table of customers, sales, employees,...

    Provide Query to create Database In this database at least a table of customers, sales, employees, suppliers, products, the detail of the sale, and the equipment (Laptop and Destop) which facilitates billing and inventory management by the database is needed. number of brands and units of computers sold at retail or wholesale. The company does not have a database and they use an old way of information that can also be easily lost. They need a database to have organized...

  • Using DDL (data definition language) statement(create table statement) to define each relation schema, i.e., giving the...

    Using DDL (data definition language) statement(create table statement) to define each relation schema, i.e., giving the create table statement for each relation schema with the definition of primary key in each table. Each employee has a name, social security number (primary key), gender, age, and salary. Each employee works for only one department, and there are more than one employee working in a department. Each department has a department name, a department number (pk), and a department location.

  • This is questions of Accounting Information Systems 1) Fo a database. Each row in this spreadsheet...

    This is questions of Accounting Information Systems 1) Fo a database. Each row in this spreadsheet represents a: ur Tet Industries tracks customer information using various Microsoft Excel spreadsheets stored in a. Field b. Record c. File d. Database 2) A d tables is a. What is the correct term for the database field in Table 1? latabase field in Table 1 that serves as a unique identifier in Table 2 and is used to link both of the a....

  • Create a Student Planner app that will allow students to keep track of homework due dates...

    Create a Student Planner app that will allow students to keep track of homework due dates for the classes they are currently taking. The first app activity (screen) will display the list of classes the student has entered. There should also be a way for students to add, edit, and remove classes from the list. When students select a class they should be taken to a second activity (screen) which will display the assignment name and due date (at minimum,...

  • (1) Use a single SQL statement to create a relational table and to load into the...

    (1) Use a single SQL statement to create a relational table and to load into the table all information about the orders submitted in 1996 or in 1998 by the customers located in Paris or in London or in Madrid. Next, enforce the appropriate consistency constraints on the new table. (2) Create a new relational table to store information about the company names of all suppliers and the total number of products supplied by each supplier. Enforce, the appropriate consistency...

  • For this set of Review Questions, we will create and use a database for the Wedgewood...

    For this set of Review Questions, we will create and use a database for the Wedgewood Pacific Corporation (WPC) that is similar to the Microsoft Access database we created and used in Chapters 1 and 2. Founded in 1957 in Seattle, Washington, WPC has grown into an internationally recognized organization. The company is located in two buildings. One building houses the Administration, Accounting, Finance, and Human Resources departments, and the second houses the Production, Marketing, and Information Systems departments. The...

  • Your team of consultants has been hired to create a database for MD Employment Agency (MDEA)....

    Your team of consultants has been hired to create a database for MD Employment Agency (MDEA). MDEA is an employment agency that contracts with the city of Miami, FL to assist displaced workers in finding new career opportunities and to help workers currently collecting unemployment benefits. Up to this point MDEA has been using standalone PCs to handle data entry of new clients and to update their status. The company also has relationships with local government agencies that have openings...

  • Describe briefly a database application case of your choice and represent your data in terms of...

    Describe briefly a database application case of your choice and represent your data in terms of 3 linked (via foreign key/s) tables. List their respective primary key and foreign key/s if any. Your database application case should be different from those already covered in the lectures or practicals. For the database case in the Additional Exercises of the previous practical, complete the proper construction of all the 5 tables in SQL, building all the pertinent primary and foreign keys there....

  • 1. Using databases for marketing research is fundamentally different from traditional marketing research in that database...

    1. Using databases for marketing research is fundamentally different from traditional marketing research in that database research: collects and analyzes individual level data costs more. relies on computers and software to develop and manage is more short oriented is easier to implement 2. Toy designers at Mattel conduct marketing research to discover how children play and what they like to play with. For Mattel, the immediate research objective is to decide whether to continue to market the old Chatter Telephone...

  • This is your opportunity to be creative! You are required to create a minimum of two...

    This is your opportunity to be creative! You are required to create a minimum of two HTML pages. The first required web page is your Home Page, which is about you. The second web page describes a place to which you have traveled or would like to travel. Each of your web pages will be graded for content, creativity, and for appropriate use of the HTML statements that have been discussed in class. You must use a text editor and...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT