Depending on the sample of interest, different ion sources are used for mass spectrometry. What ion source would you use if you wanted to examine many different small molecules and compare your results to a large database? Why?

design a relational database to cater for the needs of the new bookshop owner as described in the first question giving examples of tables, attributes, primary and foreign keys. you may assume that suppliers' orders contain more than one line

Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.

A good security system must be secured at multiple layers such as 1) database, 2) computer and 3) network. Compare the differences among these three layers. Provide one security example for each and one scenario that involves all of them.

What exactly does it mean when a plant has a scientific name that specifies a vairety, for example Nothofagus solandri var. cliffortioides, or when the name includes an "x", as in Populus maximowiczii Henry x trichocarpa, Populus xcanadensis, or "Crataegus x macrocarpa"?

All of these species are in the USDA Plants database (of plants that occur in the US). There are > 6000 occurences of the string " var. " ~500 occurances of " ssp. " and only a handful occurences of " x " in the database,

• Does the x indicate that a plant is a hybrid, and are the varied uses indicate a different meaning?
• Does the use of " var " mean that the plant is a variety?
  • Does it mean that each of these species has been cultivated and/or bred by a human?
• Does "ssp" mean that the plant is distinct yet compatible with others in the species?
• is there a way to identify a that a plant is cultivated based on its scientific name?

1. Select two companies from the same industry that are BOTH publicly traded. They need to both be traded on the New York Stock Exchange or the NASDAC stock exchange. (DO NOT SELECT CLEARWATER PAPER I USE IT IN MY EXAMPLES)

2.  Upload a screenshot of the Edgar Database files at SEC.GOV that includes the 10-K files that you need to download for EACH Company. (see attached example)

3. Upload a recent article or press release for each company discussing company operations.

4. Upload a recent 8-K from the Edgar Database at SEC.GOV. The best way to download the 8-K is to print the file to a PDF. See attached example.

see example : https://www.sec.gov/Archives/edgar/data/1441236/000156459017024717/clw-8k_20171201.htm

Design a database for an automobile company to provide to its dealers to assist them in maintaining customer records and dealer inventory and to assist sales staff in ordering cars. Each vehicle is identified by a vehicle identification number (VIN). Each individual vehicle is a particular model of a particular brand offered by the company (e.g., the XF is a model of the car brand Jaguar of Tata Motors). Each model can be offered with a variety of options, but an individual car may have only some (or none) of the available options. The database needs to store information about models, brands, and options, as well as information about individual dealers, customers, and cars. Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.

android studio

-Starting with a basic activity, create a new Java class (use File->New->Java class) called DataBaseManager as in Lecture 5 and create a database table in SQLite, called StudentInfo. The fields for the StudentInfo table include StudentID, FirstName, LastName, YearOfBirth and Gender. Include functions for adding a row to the table and for retrieving all rows, similar to that shown in lecture 5. No user interface is required for this question, t

-Continuing from , follow the example in the lecture notes 5, create a menu (or action bar items) for “Add A Record” and “View Records”. When the menu item “Add A Record” is selected, the program shows a form for entering student information. The data will be added into the database table StudentInfo. When the menu item “View Records” is selected, the program shows all records of all students.

SIS is a management information system for education departments used to manage student data. SIS provide capabilities for registering students in courses; documenting results of student tests and other assessment scores; building student schedules; tracking student attendance; and managing many other student-related data needs in a school or universities.

In this regard, you are asked to do some research about SIS, select one of the aspects that managed by SIS and then design two database tables about this aspect [14 marks] and another database table that represents a relation between the previous two tables [6 marks]. For each table you need to:

1. Define the objective(s) of the table.
2. Design at least five fields for the table; data type and size.

3.Determine the primary key of the table.

Using MySQL Workbench to write and run the following steps, and take a screenshot for me!

Create a species table and a specimen table.

In the species table, include attributes that reflect the name of the species, a general description of the species, and any other attributes you feel relevant.

In the specimens table, include an ID for the specimen, a reference to the species which it is, the date which it was observed, and any relevant details like height, weight, location, or whatever else you think appropriate.

Select appropriate data types and constraints.

Save the SQL commands for creating the tables as text to include in your lab report. Also, run these commands to create the tables in your database.

Additionally, include an ALTER TABLE ADD and an ALTER TABLE MODIFY command. Make sure these are reasonable for your database and run them as well.