Database Analysis

Design, develop business application database.

Create a database with the following three tables: CUSTOMER, PRODUCT, SALES.

Logically: One customer can complete many sales, and one product can be involved in many sales. (Note: each line item of a receipt is considered as a single sale).

Identify a primary key for each table: Customer_ID (char 5); Product_ID (char 5); Sales_ID (Char 5). The datatype for each field is listed next to it.

Each table must have at least three (3) relevant attributes.1. The CUSTOMER table must include a name.2. The PRODUCT table must include a name and price.3. The SALES table must include a date.

Each table must have a minimum of five (5) rows of data.

Create an relationship diagram linking all three tables together in Access.

Create a form and a report that support this database.

Sample Solution

Mechanism of action:
In low PH values, pantoprazole is transformed into cationic sulfenamide, which is its active form [184, 190] , this drug accumulates in the highly acidic environment of the parietal-cell canalicular lumen and it is activated. The active form, tetracyclic cationic sulfonamide, reacts with thiol groups of cysteines 813 and 822 of transmembranal H+ / K+ ATPase[183, 186]. This conversion must take place beside the gastric parietal cells, so pantoprazole must be absorped intact by GIT [184].

The pantoprazole is an acid labile drug, which undergoes degradation in the stomach [191-194]. Therefore, the drug should be targeted to the intestine; to bypass the stomach. The gastro resistant drug delivery system is designed for the acid labile drugs due to the necessity to pass intact through the stomach for reaching the duodenum for absorption. The dosage form is prepared to bypass the stomach by formulating a solution for intravenous administration (lyophilized powder for reconstitution) or as gastric‐resistant tablets (oral delayed‐release dosage form) [195]. In the case of oral administration, the enteric coating prevents the drug from degradation in the gastric juice (at pH 1–2, for a few minutes [195-197]. Therefore the enteric coating, on the acid labile drug, is essential, thus they are less affected by pH. Thus the concept of gastro resistant drugs was generated.
The wavelength of maximum absorbance for pantoprazole sodium sesquihydrate (λmax) was found to be 283.5 nm in 0.1N Hcl (pH 1.2) and 288.5 nm in phosphate buffer (pH 6.8).

Calibration curves for pantoprazole sodium sesquihydrate in each of 0.1N Hcl (pH 1.2) and phosphate buffer (pH 6.8) were assessed from absorbance values, at λmax of a series of pantoprazole sodium sesquihydrate solutions containing different concentration of pantoprazole as shown in figure (1) and figure (2).
The proposed nanoprecipitation (solvent displacement or interfacial precipitation) [143-148] method enabled the formulation of polymeric nanoparticles by using organic phase with different concentrations of Eudragit S100 (ES100) and HPMC phthalate HP55 with using Tween 80 and Poloxamer 407

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.