Any database design with no more than 5 tables Data Management Project Requireme

Question

Any database design with no more than 5 tables

Data Management Project Requirements:
The requirements include (Requirements Analysis – Data model – In physical design format):
• Background
• Purpose
• Business goals and rules
• User requirements
• Data requirements
• Reporting requirements
• Project schedule and project costs.
• Data dictionary for all tables in data model
• SQL statements:Identify the database management system (DBMS) that will be used for the database design
• minimum of two CREATE TABLE statements (for entities defined in model)
• minimum of two SELECT statements
• one insert, update or delete statement.

Transactions Financial Statements Bev's Dry Cleaners is owned and operated by Beverly Zahn. A building and equipment are currently being rented, pending expansion to new facilities. The actual work of dry cleaning is done by another company for a fee. The assets andt $14,280; summarized as follows: liabilities of the on November 1, 2019, are as follows: Cash, $29,240; Supplies, $2,720; Land, $34,000; Accounts payable , $12,240 Business transactions during November are a. Beverly Zahn invested additional cash in the business with a deposit of $27,000 in the business bank account. b. Purchased land adjacent to land currently owned by Bev's Dry Cleaners to use in the future as a parking lot, paying cash of $13,400. c.Paid rent for the month, $16,320. d. Charged customers for dry cleaning revenue on account, $4,900. e. Paid creditors on account, $2,280. f. Purchased supplies on account, $12,080 g. Received cash from cash customers for dry cleaning revenue, $26,110. h. Received cash from customers on account, $32,640. i. Received monthly invoice for dry cleaning expense for November (to be paid on December 10), $13,060. j. Paid the following: wages expense, $7,180; truck expense, $2,610; utilities expense, $2,770; miscellaneous expense, $1,240. k. Determined that the cost of supplies on hand was $1,800; therefore, the cost of supplies used during the month was $3,200. 1. Withdrew $7,500 cash for personal use. Required: ine the amount of Beverly Zahn's capital as of November 1. 2. Use the attached spreadsheet to complete part 2. Click on the Spreadsheet icon above to open and save the Excel file to your computer. Your input into the spreadsheet will not be included in your grade in CengageNOW on this problem. Enter the assets, liabilities, and indicate increases and decreases resulting from each transaction and the new balances after each transaction. owner's equity as of November 1 in equation form similar to that shown in this chapter. In tabular form below the equation,

Explanation / Answer

/*creating of database with name of chegg2*/
create database chegg2
/*using database chegg2*/
use chegg2
/*creating of table with table name of employee_details*/
create table employee_details(emp_id int,emp_name nvarchar(30),salary money,dept_id int)
/*creating of table with table name of department_details */
create table department_details(dept_id int,dept_name nvarchar(30))
/*selecting of data from employee_details*/
select * from employee_details
/*selecting of data department_details*/
select * from department_details
/*inserting of data into employee_details */
insert into employee_details(emp_id,emp_name,salary,dept_id)values(1001,'jhon',40000,1)
/*inserting of data into department_details */
insert into department_details(dept_id,dept_name)values(1,'IT')
/*inserting of data into department_details*/
insert into department_details(dept_id,dept_name)values(2,'Accounts')
/*inserting of data into department_details*/
insert into department_details(dept_id,dept_name)values(3,'Admin')
/*updating data of department_details*/
update department_details set dept_name='Hr' where dept_id=3
/*deleting data of department_details*/
delete department_details where dept_id=2

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.