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

0 0
Add a comment Improve this question Transcribed image text
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) );

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.

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
  • 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,...

  • 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...

  • IN THE PREVIOUS CHAPTER WE MADE A DATABASE USING OUR LAST NAME AS ITS NAME. QUESTION...

    IN THE PREVIOUS CHAPTER WE MADE A DATABASE USING OUR LAST NAME AS ITS NAME. QUESTION 1 STATES THIS. PLEASE TYPE WHAT NEEDS TO BE TYPED FOR ALL STEPS. THIS USES CODIO a. 1. Connect to the database you created and named in Module One (for example, Jetson). Type after the prompt mysql> a. use (table you named); i. Example: mysql> use Jetson; 2. Create the Employee table using the SQL statement shown here. Press Return after each line. CREATE...

  • Table name: Package PACK PACKNAME          &nbs...

    Table name: Package PACK PACKNAME            PACKV PAcKTYPE            PACKCOST ---- -------------      ------- -----        ------------- AC11 Quick Accounting     4.1   Accounting           754.95 AC12 Accounting MIS       4.0   Accounting          2000.00 AC13 QuickBook            2005 Accounting           300.00 DB11 Manta                1.5   Database             380.00 DB13 SQL Server           2005 Database             500.00 DB14 My SQL               2005 Database             300.00 DB22 Manta                2.1   Database             430.25 SS11 EasyCal              5.5   Spreadsheet          225.15 WP04 Word Power           2     Word Processing      118.00 WP07 Good Word            3.2   Word Processing      35.00 WP14 GOOGLE               2     Word Processing      118.00 Table name: Software...

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
ADVERTISEMENT