comp 1 swot

SQL QUESTIONS

true or false?!

Insert the following records into the tables CLIENT and CLIENT_DETAILS CLIENT Client_no Client_Name Address Order Date C100 DELL AMERICA 05-05-2018 C101 SANDISK KINGDOM 10-10-1998 C102 SAMSUNG KOREA 12-08-2010 C103 LENOVO JAPAN 10-07-1998 CLIENT_DETAILS Client_no Order_No Product Cost Quantity Status C100 R001 JIOCLASS 100.40 3000 PROGRESS C101 R002 SMARTWATCH 300.50 4000 DELIVERED C102 RO01 SPYCAMERA 600.10 2000 PROGRESS C103 R003 IROBOT 4000 DELIVERED C104 R002 RADAR 500.00 400 PROGRESS

Twitter Scrapping Bot to gather information for learning/research. Twitter scrape bot(s) which gather information on a range of topics which can be sorted into a database based off a set of requirements. The bot(s) will be able to operate 24/7, will be able to gather information based on a rule set and give each tweet a ranking on how appropriate the information is. Goal: For IT students, it consists of a brief proposal and outline of your proposed project, making some reference to the literature relevant to your project. This initial project plan will be due at the end of the first week and should be at least 1000 words..

Format the range K2:K3 with Accounting Number Format with zero decimal places. Format cell K4 with Comma Style with zero decimal places. You want to use the FORMULATEXT function to display the functions. In cell G2, insert the FORMULATEXT function to display the formula stored in cell B3. In cell G3, insert the FORMULATEXT function to display the formula stored in cell B4. In cell G4, insert the FORMULATEXT function to display the formula stored in celI D8. In cell G5, insert the FORMULATEXT function to display the formula stored in cell K2.

3 DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted. Thank you!

Department Employee • Code Name Manager • ID Name Salary 44 Engineering 2538 2538 Lisa Ellison 45000 82 Sales 3829 5384 Sam Snead 30500 12 Marketing 6381 6381 Maria Rodriguez 92300 99 Technical Support NULL In the Department table, which foreign key value violates referential integrity? 2538 3829 ○ NULL

ASAP!! ANSWER

L Consultant ConsitNum LastName FirstName Street 19 Christopher Patrick Sarah Tom 35 $1 Client ClientNum ClientName 175 299 322 363 405 449 Turner Jordan Allen Shields 458 Hershey, Jarrod Goduto, Sean Two Crafty Cousins Prichard's Pizza & Salazar, Jason Fisherman's Spot Shop Seymour, Lindsey Bonnie's Beautiful Boutique Yates, Nick Howler, Laura Harpersburg Bank MarketPoint Sales Street 135 Mill Street 12 Saratoga Parkway 9787 NCR 350 West 501 Air Parkway 733 458 554 Brown Dr. 2287 Port Rd. 82 Elliott St. 373 Lincoln Ln. 322 867 322 363 867 826 677 733 826 867 WorkOrders OrderNum OrderDate ClientNum 67101 9/6/2018 67313 9/7/2018 9/10/2018 67424 67838 67949 68252 68868 68979 9/10/2018 9/10/2018 9/12/2018 9/14/2018 9/17/2018 4091 Brentwood Ln 9565 Ridge Rd. 231 Day Rd. 1368 E. 1000 S. 65 Forrest Blvd. 826 Host St. City Tri City Easton Lizton Sunland City Easton Tri City Sunland 68252 68868 68979 68979 Lizton 56473 Cherry Tree Dr Easton FL. 49 Elwood Ave. Harpersburg FL. Amo Tri City State…

please answer 4 number

SQL Question

-Write the data commentary for the graph below. The chart below shows global sales of the top five mobile phone brands between 2009 and 2013. Add a caption and describe the graph below: 500 2009 400 2011 300 2013 200 100 Samsung Apple Nokia LG ZTE Units sold (millions)

Activity: Transform the table into 1NF, 2NF and 3NF

Displayed Submitted Answers, Correct Answers n 1 Define the use of "XML Qualified Names" with an example

Steeley Associates versus Concord Falls Steeley Associates, Inc., a property development firm, purchased an old house near the town square in Concord Falls, where State University is located. The old house was built in the mid-1800s, and Steeley Associates restored it. For almost a decade, Steeley has leased it to the university for academic office space. The house is located on a wide lawn and has become a town landmark. However, in 2008, the lease with the university expired, and Steeley Associates decided to build high-density student apartments on the site, using all the open space. The community was outraged and objected to the town council. The legal counsel for the town spoke with a representative from Steeley and hinted that if Steeley requested a permit, the town would probably reject it. Steeley had reviewed the town building code and felt confident that its plan was within the guidelines, but that did not necessarily mean that it could win a lawsuit against the…

Suppliers * SupplierlD Products Order Details Orders Customers * CustomerID V ProductID 9 OrderlD V ProductID * OrderlD CompanyName ProductName 00 CustomeriD EmployeelD OrderDate CompanyName ContactName SupplierID CategoryID QuantityPerUnit UnitPrice UnitPrice ContactName ContactTitle Quantity ContactTitle Address Discount RequiredDate Address City Region City ShippedDate ShipVia Unitsinstock 00 Region PostalCode UnitsOnOrder PostalCode Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry Employees V EmployeelD Country Reorderlevel Country Phone Discontinued Phone Fax LastName Fax HomePage FirstName Title TitleOfCourtesy Shippers V ShipperID Birthdate Categories * CategorylD HireDate CompanyName Address Phone CategoryName Description City Region Picture PostalCode Country HomePhone Extension Photo Notes Reportsto Figure 2. The relationship diagram of the NorthWind database. a. Use the ERDPlus tool to design a STAR schema of the data warehouse containing one fact…

Database audit trail: what is it? In no more than 60 words, briefly describe how SQL Server makes use of Extended Events.

Database audit trail—what is it? Explain Extended Events in 60 words or less in SQL Server.

help me to answer the question below tutorsss

Database Management Jill Bill Marketplace is a business located in Florida. Within the JBM compound, you can purchase many types of products that are related to a specific category, for example, books or antiques. JBN does not own any of the stalls that sell products, rather they rent them out to small vendors. Each vendor has to pay a monthly fee to use the Marketplace. JBM products are available to different customers who sell their products daily. Each category type (e.g. books ) is managed by a particular supervisor. A customer will order their selected product in terms of the amount from that vendor, who is also free to apply discounts on any product in his store. Other than category supervisors there are other staff that manages different departments in the mall, but they all report to two marketplace managers. The small vendors will report to the category managers on the nature of their stock and if and when restocking is required. All category managers report to the third…

Computer Science SQL Query