Answer:
There are two customers in the PostalCode.
SQL statement for select all the fields and the rows from the Customers table where PostalCode is 44000.
SELECT * FROM Customers WHERE PostalCode = "44000";
Explanation:
The SELECT statement retrieve zero or more than one row from 1 or more than one the database tables or the database views.
In most of the applications, the SELECT query is most commonly used for DQL(Data Query Language) command.
SQL is the declarative programming language and the SELECT statement specifies the result set, but they do not specifies how to calculate it.
Bookstore and BookSearch are the two entities for the given scenario.
Explanation:
- For the given Book.com virtual store, there can be two entities like Bookstore and BookSearch.
- Bookstore can have all the details of the books in the virtual store. hence the attributes can be
- Bookstore attributes: bookname, Authorname, Publisher, Publishedyear, Agegroup, category.
- BookSearch entity can be used to search the books in the virtual store.
- Booksearch attributes: bookname, category, bookid, authorname.
Answer:
Application Software Type Examples
Word processing software MS Word, WordPad and Notepad
Database software Oracle, MS Access etc
Spreadsheet software Apple Numbers, Microsoft Excel
Multimedia software Real Player, Media Player
Presentation Software Microsoft Power Point, Keynotes
Explanation:
Maia can quickly and easily adjust the spacing that exists before and after her paragraphs. To achieve this, she should select her paragraphs and click the Line and Spacing command in the Paragraph command group. She should be able to click the Add Space Before Paragraph from the drop-down menu. The paragraph spacing should change. In the same drop-down menu, she can also select the Line Spacing Option. This will open the Paragraph dialog box. This option will let her control how much space She wants before and after the paragraph. These two options are placed and indicated down below the Paragraph dialog box.
