Physics PHYS E - 1a Lecture Notes - Bigcommerce, Woocommerce, Influencer Marketing

8 views4 pages

aerial

22 Jan 2023

School

Harvard University

Department

Physics

Course

Physics PHYS E - 1a

Professor

For unlimited access to Class Notes, a Class+ subscription is required.

Document Summary

This will help you understand the demand for the products and identify potential suppliers: choose a niche: identify a specific niche or category of products that you want to focus on. It will be easier to market and promote your products if you have a niche focus: find a supplier: a supplier is a crucial part of the dropshipping model. Look for a supplier that offers a wide range of products and has a good reputation. Make sure they have a reliable shipping and returns policy: set up an online store: this is the most important step of starting a dropshipping business. You can use platforms like shopify, bigcommerce, or woocommerce to set up your own e-commerce store: optimize your store: make sure your store is easy to navigate and has a professional look. Monitor your store"s performance and make adjustments as necessary: customer service: always provide good customer service.

Related Questions

SQL Server

TASK

Is you will need to formalize the database design and use a DBMS (SQL Server, MySQL, etc) to build the database. You will NOT be required to build all the functionality as described above as part of this initial project. You will be responsible only for specific parts of the system and implementing specific features as described below. You should complete the following steps:
1. Analyze the data requirements described in the previous section. Decide which tables are required and which fields should go in which table. Normalize your design. If you wish, you may use an entity-relationship diagram. Create a table design showing the relationships between each table.
It is now time for your instructor to check your progress. After you have finished the preliminary design for the High Spirits Imports Management System, contact your instructor for a brief review.
2. Using your DBMS, create an SQL script to create the High Spirits database. Name the database HSxxxxx, where xxxxx is your student number. Save your script as step2.sql.
3. Create the tables in the HighSpirits database. You do not need to specify relationships in this script. Save your script as step3.sql.
4. Create a default database diagram. Add primary keys and relationships where they make sense. Print your diagram. Create a script that will add the necessary primary keys and foreign keys to the appropriate tables. Save your script as step4.sql.
5. Create a script that will create the needed constraints to enforce the data rules Mr. Tipple has specified. Save your script as step5.sql.
6. Using the provided source documents (see pictures 1 - 5 or download pdf file) populate your database with test data. Minimally, you need:

---->>> url for the pdf file

 4 customers (include High Spirits as a customer so you can track purchase transactions).
 5 transactions - at least 3 are sales type, 2 of which must be paid.
 4 countries, types and sizes
 6 products, each with a quantity specified
Save your script as step6.sql
7. Create a script that will show a list of customers (first name, last name, and phone number) and the total number of sales transactions they have made. Save your script as step7.sql. After running the script, save a screen capture of the output and save it as step7-output.jpg

8. Create a script that will show a list of products (product name, type, size) that have been purchased. Note: You must use an outer join for this query; a subquery is not acceptable. Save your script as step8.sql. After running the script, save a screen capture of the output and save it as step8-output.jpg
9. Create a script that will show a list of products (product name, type, size, supplier) that are from Australia. Save your script as step9.sql. After running the script, save a screen capture of the output and save it as step9-output.jpg
10. Create a script that will show a list of products (product name, type, size, customer, retail price, quantity sold). The script should also calculate the sum of the price field and the sum of the quantity sold from all times the products were sold and display it as a calculated field. Do not include purchases (Remember the status field is set to 0 for sales and 1 for purchases). Save your script as step10.sql. After running the script, save a screen capture of the output and save it as step10-output.jpg
11. Using your DBMS Help feature, explore the use of the SHOW command to display the contents of your database. Create a script that will display a list of tables in the database. Save this script as step11a.sql. Then create a script for each of the four main tables (Customers, Transactions, Products, Transaction details that will display all of the columns in the table. Save your scripts as step11b.sql to step11e.sql.
12. Finally, you will need to create the HS_Employees database. Using the data in the HS-Employees.xls spreadsheet, create a script to populate the Employees database with the data found there. Employee ID's should be unique and start with the two employee initials and then increment by a value of 1. It should be the primary key. Social Insurance numbers are unique for each individual. However, this does not make for a good Primary Key. You must ensure that there is not the ability to incorrectly enter someone else's SI number by mistake by making this field unique. Create the employee database and populate the employees table with the data as indicated above. Save your scripts as step12.sql and step12a.sql

ranplayer07

His assignment is the next step to enhance your Programming Project 1 and Homework 3 works. As for
now, you can keep the inventory in a file and upload it to the array available for your program. You have
three classes for each type of products. It is time to think about how to improve the data model – all
three types have enough in common to be child classes of one parent class.
Thus, the first thing to do is create a superclass and make three product type classes subclasses. Then,
move as many members (fields and methods) from Type X, Y, and Z product classes to a superclass as
possible. Change the constructors appropriately.
The advantage of inheritance is the ability to create an array of superclass objects to be filled with
objects of different subclasses. Thus, your inventory is in one array. Use the product’s index in the array
to build the product’s ID (I would recommend starting with 1). In the superclass, create a static variable
that holds the number of products available in the inventory. It must grow as reading from the file
progresses.
Override a default toString() method for a superclass such that it shows product ID, name, regular
price, and type.
At this moment, make sure that all modifications you have made keep your application alive and
working.
The next step is to add three new classes to the project:
• Create a class to represent the user – hardware store customer. You must decide what members
this class needs. Ask the user to input necessary information.
• You may notice that the date of the year is a complicated piece of data. Create a class Date that
converts a string of the form of “mm/dd/yyyy” into an object with three fields – month, day, and
year. The class constructor may do this job, but do not forget to check the string for correctness.
Once you have this class ready, input the date as a string with the following converting into an
object of type Date. Remember, if you read a string from the keyboard after a number, you
may need to handle the new line symbol left in the input buffer.
• The result of your application is an order that must have the customer’s information, the date,
the product information, and the total amount to pay. Thus, the third class to add is the class
Order. When all the information is collected, the order is ready to be created and printed out.
Outputting the order is the primary behavior of an object of type Order, and it is the final step
of your application. Thus, class Order aggregates the customer’s info, date, product info, and
total. Please note that Type X and Type Y products need only regular price and amount to
calculate the total, while Type Z products must also consider the date.
The input and output examples for Types Y and Z are
User: Vladimir Kuperman
The inventory:
1 Light Bulb 60W 3.0 Type X
2 Light Bulb 100W 5.99 Type X
3 Steel Bolt M5 0.15 Type Y
4 Steel Bolt M8 0.25 Type Y
5 Hose 25 feet 10.0 Type Z
6 Hose 50 feet 15.0 Type Z
Your choice: 3
Number of units: 1000
What is the purchasing date? (mm/dd/yyyy)
12/12/2021
*********************************
Date 12/12/2021
*********************************
Vladimir Kuperman
Your item:
+----+--------------+------+----+
|ID | Name |Price |Type|
+----+--------------+------+----+
|3 Steel Bolt M5 0.15 Y |
+----+--------------+------+----+
in the amount of 1000
*If you buy more than 1500 units you would pay $0.14 per unit.
*********************************
Your total: 127 dollars 50 cents
Save to file? (Y/N) Y
User: Vladimir Kuperman
The inventory:
1 Light Bulb 60W 3.0 Type X
2 Light Bulb 100W 5.99 Type X
3 Steel Bolt M5 0.15 Type Y
4 Steel Bolt M8 0.25 Type Y
5 Hose 25 feet 10.0 Type Z
6 Hose 50 feet 15.0 Type Z
Your choice: 5
Number of units: 10
What is the purchasing date? (mm/dd/yyyy)
10/12/2021
*********************************
Date 10/12/2021
*********************************
Vladimir Kuperman
Your item:
+----+--------------+------+----+
|ID | Name |Price |Type|
+----+--------------+------+----+
|5 Hose 25 feet 10.0 Z |
+----+--------------+------+----+
in the amount of 10
*********************************
Your total: 70 dollars 0 cents
Save to file? (Y/N) Y
Program requirements
The program must have one superclass and three subclasses for three types of products according to
the description given in Programming Project 1.
The program must read the inventory from the file into one array for all three types of products. Each
element of the array must be an object of one of the subclasses according to the information in the file.
Product ID must be formed automatically using a static variable.
The user must be registered in the system, and the corresponding object must be created. Then, the
user chooses a product from the list, specifies an amount and the date of planned purchasing.
The date, user, product, amount, and the total must be aggregated in an object of type Order and
outputted.
For this assignment, it is sufficient to output the order to the console. However, additional saving the
order in the file will be considered as a plus.
The test plan must be developed for the program. Consider and test different inputs that may cause
errors: incorrect file records, wrong date format, invalid user’s choice.
You have four weeks and three submission attempts for this assignment. Here is the suggested scenario
on how to plan your work:

mauvecricket73

CASE STUDY
DIVESTITURE IMPLEMENTATION COMMITTEE (DIC) PROJECT
The Divestiture Process
a. Listing of SOEs to be divested
The Government of Ghana provides the Divestiture Implementation Committee (DIC) with a list of enterprises slated for divestiture. DIC opens a file for each such company. All documentation and correspondence prepared or received in
2
connection with the enterprise is placed on this file.
Enterprises listed for divestiture are categorized by the Ministry of Finance (principally on the basis of employee numbers) into small, medium, and large. In most cases, the divestiture of large and medium enterprises is outsourced to consultants. Small enterprises are either outsourced, or divested by DIC.
b. Advertisements
Bid documents are prepared for the particular State Owned Enterprise (SOE), and the SOE is advertised for sale. Adverts should appear in at least 2 leading Ghanaian newspapers each week for 3 consecutive weeks. Adverts may also appear in foreign publications.
c. Bidding
i. Obtaining bid documents
Investors interested in a particular SOE contact the secretariat, and after filling in an application form, paying a non-refundable bid fee (¢1,000 for local investors, and $400 for foreign investors), and signing a confidentiality undertaking, they are provided with the relevant bid documents.
The bid document is made up of
• bid procedures;
• a draft sale and purchase agreement;
• a memorandum containing the profile of the SOE;
• an independent valuation report (¢ 1,000 for local investors, and $300 for foreigners);
• fixed assets valuation report (where sale of assets is the mode of divestiture);
• share valuation report (where sale of shares is the mode of divestiture).
ii. Form of bids
Investors bids should comprise of a qualification statement made up of
1. Details about the bidder, including (as relevant):
a. the bidder's full name, address and contact details;
b. details of the bidder's directors and shareholders;
c. details of the bidder's existing business;
d. financial periods; and
2. The bidder's business plan for the enterprise, including, by way of example:
3
a. plans for the development of the enterprise (with regard to both its rehabilitation and, as relevant, down-sizing of expansion) and the timing of the implementation of those plan;
b. intentions with regard to employment, proposed staff training programmes and proposals for staff participation in the enterprise;
c. marketing approach and initiatives proposed for the enterprise, including export prospects and anticipated opportunities to expand beyond traditional or existing markets;
d. impact on the local community (particularly where the enterprise has traditionally provided social services and/or infrastructure);
e. impact on competition and the regulatory environment; and
f. environment impact;
3. Confirmation that the offer for the assets or, as the case may be, shares of the
enterprise is not subject to any conditions;
a. any important points of principles arising from the draft sale and purchase agreement; and
b. confirmation that the bidder will comply with the bid procedures.
c. The bid procedures must state the requisite contents of the business plan as specifically and clearly as is possible in the circumstances. The details mentioned in 3 above will not be applicable to all enterprises.
4. A price bid.
a. the price offered for the assets or, as the case may be, shares of the enterprise (clearly indicating the proposed currency of payment);
b. if the offer is not on the basis of cash in full on completion, the precise timing of any deferred payments;
c. in the event of deferred payments, details of the security proposed to be given;
d. a detailed explanation of how the bidder intends to finance the acquisition. In the case of an offer made from existing resources, the bidder will be expected to provide written confirmation from its bank or financial adviser that the necessary funds will be available.
In the case of an offer not made from existing resources, the bidder will be expected to provide written confirmation from its arrangers or providers of finance that arrangements have been made, or will be made, to provide the necessary finance; and
5. Confirmation that the bidder has not done, and will not do, at any time any of
the following:
4
a. communicated to a person other than DIC the amount or approximate amount of the price offered (other than in confidence to the bidder's advisers);
b. entered into any arrangement with any other person that he shall refrain from bidding or as to the amount of any price to be offered;
c. offered or agreed to pay or give, or paid or given, any valuable consideration directly or indirectly to any person for doing or having done, or causing or having caused to be done, any act or omission in relation to the price offered by the bidder or any other bid
.
iii. Evaluation of Bids
This is a two stage process:
• evaluation of qualification statements; and
• comparison of price bids.
DIC opens price bids from only bidders whose qualification statements DIC accepts. In the event of equal price bids, preference is given to Ghanaians.
iv. Rejection of bids :
Bids will be rejected on the following grounds:
• received after closing date and time;
• appropriate fee not paid;
• received from person who canvassed DIC member; and
• received from SOE or a body allied to an SOE.
Exceptions under which bids may be accepted include where the assets concerned comprise non-industrial land and buildings, with no on-going business, and the bidding SOE requires additional office accommodation.
d. Negotiations
DIC will write to the winning bidder, and each other bidder, to inform them of the results of the bid.
Negotiations will then start with the winning bidder. Should he fail to satisfy DIC demands, the next highest conforming bidder will be invited to negotiate.
e. Approvals
After DIC Secretariat has agreed the terms of the sale with the winning bidder, the divestiture will be considered by the DIC members.
DIC members, if they are satisfied with the sale, will submit a letter of
5
recommendation to the President's Office for approval.
If either DIC or the President's Office raises concerns concerning the bid, a letter is sent to the bidder and further negotiations may take place.
If the President's Office grants the approval, DIC will send a letter to the bidder inviting him to sign the sale and purchase documentation. The Executive Secretary of DIC will sign on behalf of DIC and the government.
f. Payments
i. Mode of Finance
This could either be with
• investors own resource. or
• loan from a financial institution (DIC may take security over the asset until full payment is received).
In the case of instalments, for some loans, interest is paid on the diminishing balance.
ii. Terms of Payment
Payment could either be
• outright, or
• by instalments.
iii. Payment timing
• payment of less than 50% of the price offered; or
• deferred payment due 3 years after completion.
DIC prefers outright payment, but will consider deferred payment. Deferred considerations should be secured by a guarantee from a bank or other person of sufficient financial standing. If such guarantee is not available, DIC may consider taking security over the assets or, shares of the enterprise until full payment is received.
iv. Interest
Interest on deferred payments is as follows:
• Ghanaians: relevant Ghanaian Treasury Bill Rate
• Non Ghanaians: relevant London Interbank Offer Rate plus 2%.
v. Divestiture Proceeds
This will be paid to the appropriate DIC bank account.
The Proposed System
The Board of Directors of DIC has received funding from Government of Ghana
6
to commission the development of a robust and user-friendly web-based system that DIC will use for its operations.
REQUIRED:

1. Discuss the system development methodology that you would adopt for this project and justify your choice.
2. Construct data flow diagrams (including a context level diagram, a level 0 diagram, and several child diagrams) that show important, representative parts of the Divestiture Implementation Committee (DIC) System.
3. Identify five data files that will be used in the Divestiture Implementation Committee (DIC) System; and construct a comprehensive Data Dictionary for each of the five data files you have identified.
4. Construct use-case diagrams, sequence diagrams, and class diagrams for the proposed Divestiture Implementation Committee (DIC) System.
5. Construct object diagrams, activity diagrams and communication diagrams for the proposed Divestiture Implementation Committee (DIC) System.
6. Design five reports that should be generated from the Divestiture Implementation Committee (DIC) System.
7. Discuss the testing strategies/techniques that you would use on this project; and provide a table of test criteria and corresponding test data for the testing.

thomasissah74

Physics PHYS E - 1a Lecture Notes - Bigcommerce, Woocommerce, Influencer Marketing

Document Summary

Get access

Related textbook solutions

Physics: Principles with Applications

Related Documents

SMG OM 323 Study Guide - Final Guide: Radio-Frequency Identification, Process Flow Diagram, Inventory Control

COMM-2036EL Chapter Notes - Chapter 11: High Tech, Drop Shipping, Independent Business

MKT 100 Lecture Notes - Lecture 5: Retail, Marketing Mix

Related Questions