Question & Answer: Design 3 tables including properties for appropriate fields……

tbl      Design 3 tables including properties for appropriate fields.
Enter at least 5 records in each table.
tbl      Set relationships (joins) between tables
qry1   Create a query showing all fields from one table
qry2   Create a query showing fields from more than 1 table
qry3   Create a query using a sort (ascending or descending).
qry4   Create a query contain a function such as Count or Sum
frm1   Create a form for one table (shows one record at a time)
frm2   Create a form with a subform (the subform shows data from another table)
rpt1   Create a report using grouping (by one field), a page header, & page footer
Type in a separate MS Word file the following:
SQL Code – type out the code you would use.
It is optional to include in the MS Access database file.
SQL code to display all fields in one of your tables.
SQL code to display a few fields and use a sort on one of the fields.
SQL code using the COUNT function.
SQL code (that could be used) to create (from scratch) one of your tables.
SQL code to insert a new record into one of your tables.
Database Security Plan – explain in detail 3 ways to secure your database management system from cyberattacks or breeches.
List 3 future improvements (enhancements) for your system such as modifications to tables, forms, queries, and/or reports. Using database fundamentals

Expert Answer

 

1) Designing of 3 tables is given below:

Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: Design 3 tables including properties for appropriate fields……
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay

i) create table Store(Store_id int NOT NULL, Store_name varchar(255), City varchar(255), Street varchar(255), State varchar(255), Zip_code varchar(255), PRIMARY KEY (Store_id));

ii) create table Customer(Customer_id int NOT NULL, Gender varchar(255), City varchar(255), Street varchar(255), State varchar(255), Zip_code varchar(255), PRIMARY KEY (Customer_id));

iii) create table Order(Order_id int NOT NULL, Date varchar(255), PRIMARY KEY (Order_id), FOREIGN KEY (Customer_id) REFERENCES Customer(Customer_id));

2) Inserting 5 records in Store table is given below:

INSERT INTO Store (Store_id, Store_name, City, Street, State, Zip_code) VALUES (01, abc, lko, max street, newSouth, 110022);
INSERT INTO Store (Store_id, Store_name, City, Street, State, Zip_code) VALUES (02, def, lko, max street, newSouth, 110022);
INSERT INTO Store (Store_id, Store_name, City, Street, State, Zip_code) VALUES (03, jkl, lko, max street, newSouth, 110022);
INSERT INTO Store (Store_id, Store_name, City, Street, State, Zip_code) VALUES (04, mno, lko, max street, newSouth, 110022);
INSERT INTO Store (Store_id, Store_name, City, Street, State, Zip_code) VALUES (05, pqr, lko, max street, newSouth, 110022);

In the same we can enter 5 records in “Customer” table and in “Order” table.

3) Query for showing all the fields of one table is given below. Below we have show commands to display all the fields of tables Store, Customer and Order

i) select * from Store;
ii) select * from Customer;
iii) select * from Order;

4) Query for sorting is given below:

i) select * from Store orderby Store_id asc
ii) select * from Store orderby Store_id desc

5) Query with count function is given below:

i) select count(Store_id) from Store;

Grand Paper Writers
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

All papers are written by the best professional writers to ensure 100% originality. We always provide plagiarism reports whenever we deliver completed papers.

Free Revisions

All papers by Grand Paper Writers are completed and submitted on time. This timely delivery of papers gives you time to go through the paper before the official deadline.

Title-page

As an additional service, we will provide a title page that precedes the contents of your paper. Here, you will provide your personal details.

Bibliography

We also ensure that we provide an extra page for the references or bibliographies following referencing rules.

Originality & Security

At Grandpaperwriters.com, we guarantee students for the provision of security and original work. All your personal information is handled with confidentiality and is not shared with third parties. Additionally, we ensure that we provide original content with accompanying plagiarism reports to show originality.

24/7 Customer Support

Our customer support team is always available 24/7 to provide instant responses to any queries raised by students.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Grandpaperwriters.com has the best professional essay writers for quality services.

Pricing

Flexible Pricing

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Communication

Admission Help & Client-Writer Contact

Grandpaperwriters.com provides an interactive portal where students can communicate directly to their writers.

Deadlines

Paper Submission

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Reviews

Customer Feedback

Grandpaperwriters.com appreciates feedback from our clients to help us improve the delivery of essay writing services. As such, we are constantly changing our policies to ensure maximum customer and writer satisfaction.